View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default How to use indirect function?

Does anyone have any suggestions on how to use Indirect function to retrieve
the value 2318 from cell A1 for following formula in cell B1
='C:\folder\2318\[file.xls]sheet'!M$15 in cell B1
Thanks in advance for any suggestions
Eric