Finding values from 2 worksheets where item matches

Closed
Sam99p
Posts
1
Registration date
Monday April 15, 2013
Status
Member
Last seen
April 15, 2013
- Apr 15, 2013 at 11:40 AM
TrowaD
Posts
2884
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 21, 2022
- Apr 15, 2013 at 12:08 PM
Hi,
I have just start my new role where I am stuck some where
I have got 1 Order form where
SUPLIER NAME|SUPPLIER CODE |SUPLIER ITEM CODE|REF NO|ITEM CODE|DESCRIPTION
its full of data and I need to search of an 'Supplier Item Code' and against this I want to find the Ref No. where There is another work sheet of atleast 5000 products with Item code and reference number.I want all of the reference number to come on the 1st worksheet where it matches Item code.
Thanks and Please help me.

1 reply

TrowaD
Posts
2884
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 21, 2022
512
Apr 15, 2013 at 12:08 PM
Hi Sam99p,

Sounds to me like VLOOKUP is the formula for you, check it out:
http://office.microsoft.com/en-us/excel-help/vlookup-HP005209335.aspx

If I'm wrong or you need more support please let us know.

Best regards,
Trowa
0