ExcelBanter - Convert formula to range name that is recognized by vlookup formua

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Convert formula to range name that is recognized by vlookup formua (https://www.excelbanter.com/excel-programming/366980-convert-formula-range-name-recognized-vlookup-formua.html)

r wilcox

Convert formula to range name that is recognized by vlookup formua

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,FA LSE)

Thanks.

R Wilcox

All times are GMT +1. The time now is 07:26 PM.