Finding values from 2 worksheets where item matches

[Closed]
Report
Posts
1
Registration date
Monday April 15, 2013
Status
Member
Last seen
April 15, 2013
-
Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
-
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

Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
487
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