Thread: Convert formula to range name that is recognized by vlookup formua
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
r wilcox r wilcox is offline
external usenet poster
  
Posts: 14
Default 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 With QuoteReply With Quote