Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel
Previous Topic Next Topic

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

[Solved/Closed]
Report
Posts
2
Registration date
Monday August 31, 2015
Status
Member
Last seen
August 31, 2015
 -
Posts
2
Registration date
Monday August 31, 2015
Status
Member
Last seen
August 31, 2015
 -
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.

1 reply

Answer 1 / 1
Posts
2783
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
August 3, 2021
 469
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
1
Thank you
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Report
Posts
2
Registration date
Monday August 31, 2015
Status
Member
Last seen
August 31, 2015
Amazing I figured it out using the VLOOKUP. Thanks so much saved me sooo much time! :)
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!