Vlookup to the left

[jpx]

Hi,

I want to create a vlookup but instead of returning a cell to the right of the source cell I want to go one column to the left? Any ideas? Thanks.

Example I know the number 8 and want to vlookup and find 8 but return 7.

3 6
7 8

[DonkeyOte]

As you know VLOOKUP can only look left to right ... for right to left use INDEX with MATCH, eg

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

[jpx]

Great. Thank you.

[Special-K]

Or just copy the column to the right and hide it