Forum Discussion
Inserting a filename into a cell and using that cell in a formula
I have the following formula in a cell that returns the correct value. =IF($D10="","",IFERROR(INDEX([Filename.xls]SHEET1!$L:$O,$Z10,2),"")) This formula is used many times in the worksheet so I...
Hi
To extract the File name in a Cell, Say A1, type
=Cell("filename")
To use it in a formula say in A2 I just want to keep the Sheet name, Type in A2
=REPLACE(A1,1,FIND("]",A1),"")
Hope that helps
Nabil Mourad