professor

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)

=VLOOKUP($C7,INDIRECT(“‘”&INDEX(SheetList,MATCH(1,–(COUNTIF(INDIRECT(“‘”&SheetList&”‘!$d$6:$e$200″),$C7)>0),0))&”‘!$d$6:$e$200″),2,0)

This works for a single worksheet:

=INDEX(Railway!$B$6:$B$25,MATCH(C18,Railway!$D$6:$D$25,0))

 

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

 

Thanks

By: Stuart Donnan

Leave a Reply

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