I have the following formula, but source data [19Sep2023 Tue.xlsm] will change daily.
Rather than changing all the formulas in every VLOOKUP, can I put the external file name in a single cell and get all VLOOKUP's to reference that one cell. Sure it must be possible but not getting it to work. I could use find and replace, but trying to find a neater, more user-friendly way.
=TEXT(VLOOKUP(F5,EZY!$A$7:$V$903,5,FALSE),"0") & " " & TEXT(VLOOKUP(F5,'[19Sep2023 Tue.xlsm]DOR'!$A$5:$I$168,8,FALSE),"hh:mm")
Rather than changing all the formulas in every VLOOKUP, can I put the external file name in a single cell and get all VLOOKUP's to reference that one cell. Sure it must be possible but not getting it to work. I could use find and replace, but trying to find a neater, more user-friendly way.
=TEXT(VLOOKUP(F5,EZY!$A$7:$V$903,5,FALSE),"0") & " " & TEXT(VLOOKUP(F5,'[19Sep2023 Tue.xlsm]DOR'!$A$5:$I$168,8,FALSE),"hh:mm")