parsing a formula...

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

bj

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

Greg Wilson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top