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
Bookmarks