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" wrote:

Sheet1 A1 = apples

Enter this formula on Sheet1 cell B1:

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

Copy down as needed.


--
Biff
Microsoft Excel MVP


"FJ" wrote in message
...
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.