vlookup

[Guest]

I applied VLOOKUP to find the text associated to the left of a minimum value.
Eg:
A B
-------------
Hello 1.5
Hi 3.2
Hey 1.2

=min(B1:B3) returns 1.2
=Vlookup(min(B1:B3), A1:B3, 1, FALSE) returns "N/A" error, when I exptected
"Hey" to be returned. It works if I swap the columns, but I cannot swap them.

Is there are better way to get the text "Hey" associated to the minimum
value in the list in column-B. I was suggested to use OFFSET, but don't know
how.

 

[Jason Morin]

There's a couple of ways. Here's one:

=INDEX(A:A,MATCH(MIN(B:B),B:B,0))

HTH
Jason
Atlanta, GA

 

[Paul Corrado]

VLOOKUP cannot return a result that is to the left of the lookup column.

Use

=INDEX(A1:A3,MATCH(MIN(B1:B3),B1:B3,0))