reference file
In your example FILE is a SHEET name rather than a file name, isn'it? If so,
sheet name being in A1
=INDIRECT(A1&"!C4")
Regards,
Stefi
€˛Miree€¯ ezt Ć*rta:
I have this formula that works fine, is there a way to replace the file to
reference a cell, so that I can just change the file name in one cell rather
thn the many the formula appears in?
=IF(FILE'!$C4="","",'FILE'!$C4))
|