Pulling in Data from a cell

[raccoon588]

='\\hinas1\mfg\QRQC\Auxilary\[QRQC A7 fy19.xlsm]OEE'!$G$11

Can the fy19 in the formula be replace with a cell location and full in whatever year i place into the cell?

 

[James006]

Hello,

It would a two-step formula :

=MID(A1,FIND(".xlsm",A1,1)-4,4)

=SUBSTITUTE(A1,MID(A1,FIND(".xlsm",A1,1)-4,4),"fy20")

Hope this will help