Indirect formula errors if file is closed

M

Madiya

Sorry as this is not correct group for formulas but could not get any reply on my post in microsoft.public.excel.worksheet.functions

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
 
G

Gord Dibben

Did you check out Excel Help on indirect function?

In part it reads: •If ref_text refers to another workbook (an
external reference), the other workbook must be open. If the source
workbook is not open, INDIRECT returns the #REF! error value.

If not, time to do so perhaps.

Gord
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLookup and Indirect 3
Custom function for vlookup 11
Update link on vlookup from closed excel file 2
Indirect to a closed workbook 1
Need help in using INDIRECT, SUBSTITUTE, and OR in a formula fordependent dropdown list 2
Copy and close code 4
indirect? 1
Calculating(Processors(2)): % 1

Top