Search word from list, match it copy values next to it [Solved/Closed]

Question

Search word from list, match it copy values next to it [Solved/Closed]

Report

haris1989

Posts: 2
Registration date: Monday August 31, 2015
Status: Member
Last seen: August 31, 2015

- Aug 31, 2015 at 11:48 AM
haris1989

Posts: 2
Registration date: Monday August 31, 2015
Status: Member
Last seen: August 31, 2015

- Aug 31, 2015 at 12:30 PM

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.

Search word from list, match it copy values next to it
Vim search word - How-To - Linux
Search word google - How-To - Google Chrome
Search for multiple substrings and return different values ✓ - Forum - Excel
Search column B for matching value from a row in column A .... ✓ - Forum - Excel
Searching for values and creating a list ✓ - Forum - Excel

1 reply

Ask a question

TrowaD · Accepted Answer · 2015-08-31T12:04:41-0400

Answer 1 / 1

TrowaD

Posts: 2670
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: October 22, 2020

446
Aug 31, 2015 at 12:04 PM

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

Report

haris1989

Posts: 2
Registration date: Monday August 31, 2015
Status: Member
Last seen: August 31, 2015

Aug 31, 2015 at 12:30 PM

Amazing I figured it out using the VLOOKUP. Thanks so much saved me sooo much time! :)

Your reply