I am trying to use the formula MAX(A1:A100) where both the cell references are in fact results of other formulas ie A1 is actually this...

(code in cell AH29)
=CELL("Address",INDEX($J16:$J816,COUNTIF($J16:$J816,"<"&AB26)+1,1))
and A100 is actually this...

(code in cell AG29)
=CELL("Address",INDEX($J$16:$J$816,MATCH(AA26,$J$16:$J$816,TRUE),1))
At the suggestion of another user, I've got the following

=MAX(INDIRECT("J16:"&AG29))
which gives me the max between cell J16 and the cell referenced in AG29, but what I would like to do it have both the two cells at either end of the range (J16 in this case) the result of an indirect or similar.

Any thoughts about how to make my MAX formula? If you need more to re-word this, let me know!

To summarise, I want a MAX formula, where both cell references are results of other formulas. How do I achieve this?