You may want to use =index(match) instead.

Debra Dalgleish explains it:
http://www.contextures.com/xlFunctions03.html

You could use:

=index(sheet2!c:c,match(a1,sheet2!z:z,0))

to grab something from column C (of the same row) based on a match in column Z.

Or
=index(sheet2!c:c,match(a1,sheet2!z:z,0)+99)
to grab something from column c, but 99 rows after the match in column Z.


QuietMan wrote:

does anyone know how to use the indirect and offset worksheet function to
return the value of a cell base based on a where the vlookup value is found
on a work sheet
--
Helping Is always a good thing

--

Dave Peterson