View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
txm49 txm49 is offline
external usenet poster
 
Posts: 17
Default 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.