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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 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.
Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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