MAX function in Excel is it possible to provide the range by means of variables

Question

In order to calculate the MAX of a range, I'm attempting to develop an excel formula. References are recognized by the default formula as the limits of the admissible range of arguments:

=MAX(A1:A10)

By entering them in specific cells, I want to make the range's boundaries into variables, like:

=MAX(A"number of row taken from the content of cell B2":B"number of row taken from the content of cell B3)

See the attached screenshot.

Is this format supported by Excel? If yes, what's the correct syntax? Thank you!

Answer 1

Try this:

=MAX(INDEX(A:A,B2):INDEX(A:A,B3))