How to name a sheet list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Just use the names of the sheets you are targeting. The formula will
INDIRECT into those sheets.

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
i could use {"Sheet1"; "Sheet2";....} but if I have 50 sheets, I should be
able to group them using the Name function right? I tried going into
Insert->Name->Define and making MySheets = 'Sheet1:Sheet50!' but it doesnt
seem to work in the formula.
 
Back
Top