vlookup to the left

[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.

 

[Frank Kabel]

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

 

[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.