Hi,
I have the below original formula for Xlookup which works fine.
Original Formula: =XLOOKUP(E3,'[8th August 2022 Report.xlsx]Sheet1'!$B:$B,'[8th August 2022 Report.xlsx]Sheet1'!$T:$T,,0))
Now, the date of the filename changed everyday, eg, 9th August then 10th August etc... therefore I manually enter the date in Cell T1 (so I don't have to change the formula everyday) and incorporate into the formula using CONCATENATE(T1," 2022 Report.xlsx"). I am hoping someone could assist me with the end formula. Something like below. I am confused as to whether or not to include '[ in the CONCATENTATE formula.
=XLOOKUP(E3,CONCATENATE($T$1," 2022 Report.xlsx"]Sheet1'!$B:$B,CONCATENATE($T$1," 2022 Report.xlsx"]Sheet1'!$T:$T,,0))
Thank You in advance.
Joey
I have the below original formula for Xlookup which works fine.
Original Formula: =XLOOKUP(E3,'[8th August 2022 Report.xlsx]Sheet1'!$B:$B,'[8th August 2022 Report.xlsx]Sheet1'!$T:$T,,0))
Now, the date of the filename changed everyday, eg, 9th August then 10th August etc... therefore I manually enter the date in Cell T1 (so I don't have to change the formula everyday) and incorporate into the formula using CONCATENATE(T1," 2022 Report.xlsx"). I am hoping someone could assist me with the end formula. Something like below. I am confused as to whether or not to include '[ in the CONCATENTATE formula.
=XLOOKUP(E3,CONCATENATE($T$1," 2022 Report.xlsx"]Sheet1'!$B:$B,CONCATENATE($T$1," 2022 Report.xlsx"]Sheet1'!$T:$T,,0))
Thank You in advance.
Joey