Thread: reference to an external file
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Alberto Ast[_2_] Alberto Ast[_2_] is offline
external usenet poster
  
Posts: 181
Default reference to an external file
If I want to copy one cell from another file I will do

=[FileName.xls]SheetName!$I$10

But if I want the file to vary depending on a cell A1 value... I mean

If cell A1 value is equal to Q1 then file name will be [Q1 FileName.xls]
If cell A1 value is equal to Q2 then file name will be [Q2 FileName.xls]

How do I make a formula so the file name depend on the cell value
I tried [A1&" FileName.xls"]SheetName!$I$10 but did not work....
How can I do it?
Reply With QuoteReply With Quote