Forum Discussion

Copper Contributor

Oct 26, 2021

File name in a formula.

Is there a way to refer to an Excel file in a formula by using the content of a specific cell ? In the cell G48, I'm entering manually the file name but I would like to take the content of the...

Formulas and Functions

SergeiBaklan

Diamond Contributor

Oct 26, 2021

JMW89

It could be

=INDIRECT("'c:\gsa..[" & A48 & "]fiche'!$B$7")