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
Multiple VLOOKUP in an IF statement 2
VLOOKUP & Data Validation 0
Help With VLOOKUP 2
Newbie Help - IF Yes No Function 0
Vlookup 1
VLookup + IF 5
Use vlookup within offset? 4

Top