| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| value not recognized as a formula | Excel Worksheet Functions | |||
| value not recognized as a formula | Excel Worksheet Functions | |||
| value not recognized as a formula | Excel Worksheet Functions | |||
| Convert Range name in cell for VLookup | Excel Worksheet Functions | |||
| need a formua for wages | Excel Programming | |||
Linear Mode
