Search word from list, match it copy values next to it

Solved/Closed
haris1989 Posts 2 Registration date Monday 31 August 2015 Status Member Last seen 31 August 2015 - 31 Aug 2015 à 11:48
haris1989 Posts 2 Registration date Monday 31 August 2015 Status Member Last seen 31 August 2015 - 31 Aug 2015 à 12:30
I have a list of product part numbers in one excel document. Now I need to pull the description and pricing from another document which is attached in the rows to each part number.



I have started manually already but it will take me hours and hours to match everything.



The second image displays the excel document where the data is coming from.
Related:

1 response

TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
31 Aug 2015 à 12:04
Hi Haris,

Good thing you stopped after manually inputting 4 rows.

VLOOKUP is the formula you are looking for. Write 1 formula for the D column and one for the E column and then drag both down.

Do let us know if you can't get it to work.

Best regards,
Trowa
haris1989 Posts 2 Registration date Monday 31 August 2015 Status Member Last seen 31 August 2015
31 Aug 2015 à 12:30
Amazing I figured it out using the VLOOKUP. Thanks so much saved me sooo much time! :)