Vlookup Offset help

S

steven.britton

I want to do a vlookup on from one worksheet to another - When I find
the value I'm looking for I want to return the next column, but one
row above.

Function?

thanks!
 
M

Mike H

Hi,

You would use index match for that

=INDEX(Sheet2!B1:B20,MATCH(A1,Sheet2!A1:A20)-1,0)

This looks for the value in a1 on the current sheet in column A of sheet 2
and returns column B 1 row up

Mike
 
Top