I have the following formula where I am trying to look up data from different
range names(ie Scenario 1, Scenario 2, etc). How do I get the vlookup formula
to recognize the formula "=REPLACE("Scenario",25,0,Opt)" as the range name?


=VLOOKUP($D31,REPLACE("Scenario",25,0,Opt),AA$4,FALSE)

Thanks.

R Wilcox