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