reference to cells with variable rownumbers to be found in another cell

[Inge Borghgraef]

I want to use the formula MAX(C3:C8) (or any other formula in fact), but instead of the indices 3 and 8 I would like to indicate two numbers that are to be fetched from a certain cell (or 2 cells of course).
For example : cell A23 contains 5 and cell A24 contains 12, and I would like to see the result of the formula MAX(C5;C12) automatically.
Thank you for looking at the problem

 

[wideboydixon]

=max(indirect("c"&a23&":c"&a24))

wbd

 

[Inge Borghgraef]

Thanks!

 

[FormR]

Hi, welcome to the forum!

Here is another option that you can try that avoids the INDIRECT() function.

=MAX(INDEX(C:C,A23):INDEX(C:C,A24))

 

[wideboydixon]

Hi, welcome to the forum!

Here is another option that you can try that avoids the INDIRECT() function.

=MAX(INDEX(C:C,A23):INDEX(C:C,A24))

Yep - that's a better solution.

WBD