VLOOKUP or MATCH or ?
You're welcome. Thanks for the feedback!
--
Biff
Microsoft Excel MVP
"FJ" wrote in message
...
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.
|