I would like to modify the following formula such that the cell
address J$8354 is replaced by a dynamic cell address formula.

The original formula (in array format) is:
{=CELL("address",INDEX(J$8:J$8354,MATCH(MAX((J$8:J $8354<=K$6)*J$8:J
$8354),J$8:J$8354,0)))}

The dynamic formula that would substitute cell address J$8354 is:
=ADDRESS(MATCH(99^99,J:J),10)

Unfortunately, when I merge the two formulas together, I get an
error... Is it even possible to do what I have in mind without
resorting to VBA?

Thanks.

--
tb