| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Indirect to a closed spreadsheet | Excel Programming | |||
| Indirect to a closed workbook | Excel Programming | |||
| VLOOKUP from closed file using INDIRECT function | Excel Worksheet Functions | |||
| INDIRECT function do not work when other file is closed | Excel Discussion (Misc queries) | |||
| Use INDIRECT function to reference a value in closed file | Excel Worksheet Functions | |||
Linear Mode
