IFERROR or ISERROR or something if no file or no tab

[mayday1]

I have a report with links to files that might not exist and to tabs that might not exist (but are in files that do exist). I'd like my report to be the same every month requardless so the same file works every month whether or not certain files or tabs are missing.

How can I do something like this below that will make a cell empty if there's no file on a particular day or if the file is there but one of the many tabs is not there because there was no data for that particular tab?

=IFERROR(VLOOKUP($B32782,'[MyFile.xlsx]MyTab'!$E$2:$F$4000,2),"")

 

[mayday1]

 

[mayday1]

To elaborate for someone searching for the answer, I've been told it's not possible.

 

[Yongle]

I do not think you can do this by standard Excel formula

Perhaps this apprach
- use workbook (W) as a template
- at report time.. copy W and save as T
- in T replace non-valid MyFile!MyTab formulas with blanks (see below)
- save T and run report

Practically ...
- maintain a list of external workbook\tab combinations
- use VBA to identify those which do not exist this month
- use VBA to loop through all formulas replacing the "bad" ones