VLOOKUP or MATCH or ?

[FJ]

Hi, I'm trying to write a formula that will look up something in column A
and, if it finds a match in column A in another spreadsheet, will return the
value of that match that is in the same row in column H.

In other words, if I have "Apples" in column A of spreadsheet 1, I want to
look up "Apples" in column A of spreadsheet 2, see what text or value is in
the corresponding cell in the same row in column H, and show that value in
column H of spreadsheet 1. I hope I explained that clearly.

I have tried using VLOOKUP, INDEX, and MATCH in various different ways but I
can't seem to get anything to work. I usually just get a 0 result. I know
this is probably something very simple but I guess I'm really missing
something somewhere and I have literally thousands of items I have to look
for. Can anyone help?

Thanks in advance for any information.

 

[T. Valko]

Sheet1 A1 = apples

Enter this formula on Sheet1 cell B1:

=INDEX(Sheet2!H:H,MATCH(A1,Sheet2!A:A,0))

Copy down as needed.

 

[FJ]

Hi, I just wanted to say thanks so much for your help! Your formula
worked great and you saved me many, many hours of work! Thank you so much!

 

[T. Valko]

You're welcome. Thanks for the feedback!