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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks