M
Madiya
I am using indirect formula in vlookup to get values from a specific date.
All data files are named as "myfile yyyy mm dd.xlsx"
Indirect formula refers to a date for which I want to lookup values.
Vlookup formula with embeded indirect works file as long as target file is open.
The moment I close the target file all results turn to ref error.
I want to get the values without opening file.
Pl help.
Regards,
Madiya
All data files are named as "myfile yyyy mm dd.xlsx"
Indirect formula refers to a date for which I want to lookup values.
Vlookup formula with embeded indirect works file as long as target file is open.
The moment I close the target file all results turn to ref error.
I want to get the values without opening file.
Pl help.
Regards,
Madiya