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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup to reference offset 1
VLOOKUP and OFFSET 3
Use vlookup within offset? 4
Help with Vlookup and MAX functions 4
Excel IF statement with vlookup 2
Help With VLOOKUP 2
Vlookup and return sheet name also 2
Return a Value in Vlookup Q 3

Top