Opv
12-10-2010, 11:29 AM
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?
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?