Thread: How to name a sheet list
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
J@Y J@Y is offline
external usenet poster
  
Posts: 127
Default How to name a sheet list
I have this formula that uses MySheets as a list of sheets.

=VLOOKUP(A2,INDIRECT("'"&INDEX(MySheets,MATCH(1,--(COUNTIF(INDIRECT("'"&MySheets&"'!A2:A200"),A2)0) ,0))&"'!A2:C200"),3,0)

How would I name my sheets?
Reply With QuoteReply With Quote