Quote:
Originally Posted by joeu2004[_2_]
"flossy129"
Caveat: The use of INDIRECT makes this a "volatile" formula. It will be
recalculated usually unnecessarily whenever Excel recalculates anything in
the Excel workbook; for example, whenever any cell in any worksheet is
modified. INDIRECT could be avoided by the judicious use of INDEX, which is
not "volatile". However, that has its downside as well. For now, I would
suggest that you stick with INDIRECT as long as there are not many such
formulas in the workbook.
|
I am awed by your solution, inelegant or otherwise (sadly not that I would know an inelegant formula). It works.
The spreadsheet it is being used in has many formulas - mostly simple IF or VLOOKUP functions - but it seems to work perfectly.
I cannot express how grateful I am to you for the solution and your perseverance.
Thank you again.
flossy129