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
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.
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:
- Finding values from 2 worksheets where item matches
- Tentacle locker 2 - Download - Adult games
- Feeding frenzy 2 download - Download - Arcade
- Fnia 2 - Download - Adult games
- My cute roommate 2 - Download - Adult games
- Resident evil 2 remake free download - Download - Horror
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Apr 15, 2013 at 12:08 PM
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
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