Thread: Variable Names in Formulas
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
papou
 
Posts: n/a
Default Variable Names in Formulas
Hello
Use INDIRECT to build the variable range reference:
=Sum(INDIRECT("Variable"&Q1&Q2,TRUE))

HTH
Cordially
Pascal


Reply With QuoteReply With Quote