If the initial match value willl be in column A
=index(A1:J600, Match(value,A:A,0)+2, column_num)
would work

If the match value can be in any column, it gets more complicated
can it?


"txm49" wrote:

I want to search an array for an initial value and then return the value 2
rows below that value. The initial value could be in an array from a1:j600.
I'm trying to nest a VLOOKUP in an OFFSET, but its not working probably
because offset expects a cell address.

Therefore, I think what I need is to drive the cell address and nest that
within the offset. Don't know how to do that.