Reverse V-Lookup

[jamieleeuk]

Hi,

I have a table lets say A1:M50 in sheet 2.

I'm using a vlookup on sheet 1 to search in that table.

The matching criteria will be in column B in that table.

The result I want it to return is in column A.

I have tried the following vlookup formula but I get an N/A.

=VLOOKUP(A2,Sheet1!A2:L1065,-1,false)

I think it's the -1 that's causing the error but how else can I make the vlookup formula return a match to the left of the matched criteria?

All help greatly appreciated.

Thanks in advance

 

[Richard Schollar]

Hi

Use INDEX/MATCH:

=INDEX(Sheet1!$A$2:$A$1065,MATCH(A2,Sheet1!$B$2:$B$1065,0))

 

[jamieleeuk]

Perfect Richard, thanks!