View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave F[_2_] Dave F[_2_] is offline
external usenet poster
 
Posts: 187
Default parsing a formula...

Help me interpret this formula:

=OFFSET(INDIRECT(ADDRESS(ROW(INDEX(F24:F27,MATCH(I 5,F24:F27,0))),COLUMN(INDEX(F24:F27,MATCH(I5,F24:F 27,0))))),,
1)

As far as I can tell, this returns the value one cell to the right of
the cell address returned from the
ADDRESS(ROW(INDEX(F24:F27,MATCH(I5,F24:F27,0))),CO LUMN(INDEX(F24:F27,MATCH(I5,F24:F27,0))))
part.

Correct? Is there a more concise way of doing the same thing?

Thanks.