Need to search Book 2 for matching value and return a result in Book 1

[tvandenburg]

Hello,

I'm new to excel and have been tasked with importing thousands of matching values...
I know my example will seem pointless, but obviously it is part of a much bigger picture.

I have 2 workbooks.
Book 2 has a Part number and a vendor.
Book 1 only has a list of part numbers...

I need a formula to search book 2 for the matching part number and return the text in the vendor column into Book 1.

FYI: Book 2 has approximately 20,000 part numbers. While Book 1 has only 5,000

I attached a rudimentary example.

Thank you for any help!

[jeffreybrown]

Try this

=VLOOKUP(A2,[Book2]Sheet1!A2:C8,3,0)

[tvandenburg]

Thank you for the quick reply. I tried to adjust the numbers to fix my actual books... and failed.

Let me post more accurate representations of my 2 books.

[jeffreybrown]

How about

=INDEX([Book2.xlsx]Sheet1!$F$2:$F$10,MATCH(A2,[Book2.xlsx]Sheet1!$C$2:$C$10,0))

[tvandenburg]

I couldn't get it to work using different workbooks... so I copied the relevant sheet into the same book and it works!

Thanks

[jeffreybrown]

Well glad you got that to work, but if you use the same concept and now move the sheet to its own workbook, the formula should follow.

You are very welcome and thanks for the feedback.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.