you might catch this error with theIFERROR functionand display a custom result if you like.
INDIRECT is useful when you want to assemble a text value that can be used as a valid reference.
Dynamic workbook reference
To build a dynamic worksheet reference – a reference to another workbook that is created with a formula based on information that may change – you can use a formula based on the INDIRECT function. In the example shown, the formula in E6 is: =INDIRECT("'["&B6&"]"&C6&"'!"&D6) Note: the external workbook must be open for this reference to work.
