View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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.