Indirect formula errors if file is closed
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 times are GMT +1. The time now is 06:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com