Some thoughts.. On the face of it, if the VLOOKUP evaluates to a defined
range, think we could try wrapping INDIRECT around the VLOOKUP, so something
like this should work:
= OFFSET(INDIRECT(VLOOKUP(D3,'02-00W-In$ight'!O7:X19,1,0)),0,-9)
The above OFFSET expression would need to be array-entered* if the defined
range returned is a multi-cell range, should the expression be in a cell on
it's own, i.e. not nested within other functions.
*press CTRL+SHIFT+ENTER, instead of just ENTER
... VLOOKUP(D3,'02-00W-In$ight'!O7:X19,1,0)
But .. think the VLOOKUP above evaluates the same as just having: = D3 ? If
so, perhaps simply having:
= OFFSET(INDIRECT(D3),0,-9)
would do it
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Rob M." <Rob wrote in message
...
I am trying to use and offset that starts the reference by utilizing a
vlookup .
OFFSET(VLOOKUP(D3,'02-00W-In$ight'!O7:X19,1,0),0,-9)
This is what I have - it returns an error saying the formula contains an
error
help is appreciated.. thanks