parsing a formula...

  • Thread starter Thread starter Dave F
  • Start date Start date
D

Dave F

Help me interpret this formula:

=OFFSET(INDIRECT(ADDRESS(ROW(INDEX(F24:F27,MATCH(I5,F24:F27,0))),COLUMN(INDEX(F24:F27,MATCH(I5,F24:F27,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))),COLUMN(INDEX(F24:F27,MATCH(I5,F24:F27,0))))
part.

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

Thanks.
 
maybe
=indirect("R"&match(I5,F24:F27,0)&"C6",0)
the row(index())will just be 23 plus the match function
the column Index F...) will always give a 6 so to go over one just make the
column be 7 to go one to the right.
 
I'm at a loss as to how it does anything more than this except that it does
it in a roundabout manner:

=VLOOKUP(I5, F24:G27, 2)

Greg
 
Back
Top