I have about 20 worksheets with data in similar format. I have VLOOKUP working fine with multiple worksheets in a SheetList, to bring selected information into a new worksheet. But this won’t work looking left. I can search one worksheet by Index-Match but I do not know how to use the SheetList in the index and match functions to search all the worksheets at once.

This works fine (my personal arrays)


This works for a single worksheet:



Can someone advise about how to incorporate the SheetList (a named array of all the worksheet names) into INDEX and into MATCH.



By: Stuart Donnan

Leave a Reply

Your email address will not be published. Required fields are marked *