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.

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.

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

"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.

I agree, but I think the OP wants an exact match

=VLOOKUP(I5, F24:G27, 2, 0)


"Greg Wilson" wrote:

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

"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.