Need to use a text string from another cell as a variable range in another equation.

Hello,

I am using an array formula which references a static range currently. I would like to use a text string from another cell as a variable, and then enter this range, written as a text string, and insert into the equation below.

Please Login or Register  to view this content.

The text string is below. Please note the ranges are the same for this example but change cell to cell.

Please Login or Register  to view this content.

Any help would be appreciated.

Thanks!

To ask the question in an easier way...

I want to do the following:

Change the equation

=MAX(B$30:B$58)

into

=MAX(B3) where cell value of B3 = B$30:B$58

Can this be done?

Awesome! Had no clue about the "indirect" function.

Thank you so much!