offset off a vlookup?
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.
|