In my example I can use INDIRECT with VLOOKUP to work on named ranges within other workbooks BUT only if the other workbooks are open.

INDIRECT does not work with closed workbooks.