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.

"Dave F" wrote:

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.