MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Indirect and Address w/in formula


Posted by Lynda on February 15, 2002 7:04 AM

Hello,

Can you tell me exatcly what the following formula is supposed to do:

=IF(ISERROR(F29),0,LOOKUP(C29,INDIRECT(ADDRESS(F29,5,,,F$1)):INDIRECT(ADDRESS(F29,15,,,F$1)),INDIRECT(ADDRESS(F29+1,5,,,F$1)):INDIRECT(ADDRESS(F29+1,15,,,F$1))))

I have a previous employee's spreadsheet that needs changes made to it. All but a couple items come out w/correct new data when the changes were made. Those that don't come out w/the correct new data, appear to have the same formula as those that do. So, what I'm trying to figure out is what the above formula is exactly telling the cell to do.

Thank you.


Posted by Lynda on February 15, 2002 8:00 AM

My apologies...

Please disregard this question. My original question (identical to this one) did go through and is listed elsewhere on the Message Board.