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.

=OFFSET(INDEX(B$30:B$58,MATCH(MIN(ABS(B$30:B$58-B97)),ABS(B$30:B$58-B97),0)),0,B$79)

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

B$30:B$58

Any help would be appreciated.

Thanks!