Thank you.

Mr Shorty, I could not open your attachments but my IF statement is very simple If(A2="","", Index(Match()) ). I wouldn't perform the lookup since I know a result is not required.

Many of the Index(Match()) are looking at an Excel Tables in another workbook, which does require that workbook to be open. (It opens automatically in read-only with the sheets hidden.)