Combining OFFSET and VLOOKUP

[Opv]

This question pertains more to combining the OFFSET and VLOOKUP functions within EXCEL, rather than in VBA.

I have the following function:

=VLOOKUP($E$4,Data,13,FALSE)

I am attempting to change it to:

=OFFSET(VLOOKUP($E$4,Data,13,FALSE),-1,0)

This is resulting in a formula error.

How would I combine OFFSET with the original VLOOKUP formula so that once the VLOOKUP function returns the proper cell, that cell is then OFFSET by -1 rows?

[austenr]

I would use INDEX and MATCH like this example:

=OFFSET(INDEX(Sheet3!$B$1:$B$1335,MATCH(A1,Sheet3!$B$1:$B$1335,FALSE),1),1, 1,1,1)


You will need to adjust your references to suit.