Use INDEX and MATCH instead

=INDEX(Y3:Y4000,MATCH(B33,O3:O40000,0)-1)

might work


--
Regards,

Peo Sjoblom


"Danni2004" wrote in message
...
I would like to create a function that will lookup one particular cell in a
set range and instead of returning the value found in the range, make the
output be the cell that is one row up and 10 colums over from the found
cell
in range.

Here's what I've tried so far:
=offset(VLOOKUP($B33,$O3:$Y40000,11,FALSE),-1,0,1,1)
OR
=offset(LOOKUP($B33,$O3:$O40000),-1,10,1,1)

But Excel told me I had an error and it won't accept the equation.
Can you use a LOOKUP function as the reference in the OFFSET function?
If so, how should I write it?

Thanks!
Danni