vlookup to the left

N

nepentanova

i know vlookup in its standard form can only lookup a value in the
table and return a value x columns to the right.
Is it possible to find a value in a table, and return the value on the
corresponding row TO THE LEFT OF THE FOUND VALUE?
Any help / workarounds would be appreciated.
 
F

Frank Kabel

Hi
you may use a combination of MATCH/INDEX. e.g.
=INDEX(A1:A100,MATCH(value,B1:B100,0))
 
J

JE McGimpsey

Not using VLOOKUP, but

=INDEX(A:A,MATCH("test",F:F,False))

will return the value in column A corresponding to the first cell with
"test" in column F.
 
Top