Good morning,

How can I replace part of the file name of my formula using a cell value? For example let's say at cell A1 I have the value ABCD which will be used as a part of mine formula file name.
I have several cells with the similar formula below, but lets use only one as an example:


=AVERAGEIFS('C:\IGA\[6271.xlsx]6271'!$I$2:$I$894751,'C:\IGA\[6271.xlsx]6271'!$C$2:$C$894751,$A32,'C:\IGA\[6271.xlsx]6271'!$D$2:$D$894751,$B32,'C:\IGA\[6271.xlsx]6271'!$M$2:$M$894751,$B$2,'C:\IGA\[6271.xlsx]6271'!$O$2:$O$894751,$C$2,'C:\IGA\[6271.xlsx]6271'!$G$2:$G$894751,$A$2,'C:\IGA\[6271.xlsx]6271'!$H$2:$H$894751,H$31)


So in the above formula I would like to replace all 6271 values to the value I inserted on cell A1 which is ABCD.... Then later if I want I can change to another file name like EFGH...

Thanks!