Thread: INDIRECT lookup of sheet names
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Samo
 
Posts: n/a
Default INDIRECT lookup of sheet names
Hi,

You can use the following formula:

=if(ISERROR(INDIRECT("'"&$B64&"'!I$15"))=True,0,=I NDIRECT("'"&$B64&"'!I$15"))

Samo

Reply With QuoteReply With Quote