View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alberto Pinto
 
Posts: n/a
Default INDIRECT function

Hi!

is it possible to return this kind of string from the indirect function
(to use in a LOOKUP function):

'VARIABLE'!B$13:B$46

where VARIABLE is in the cell A1, and gives me the worksheet to lookup
the values.

Thanks in advance