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?

How to name a sheet list
 

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)

"J@Y" wrote in message
...
I have this formula that uses MySheets as a list of sheets.


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

How would I name my sheets?

How to name a sheet list
 

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.

"Bob Phillips" wrote:

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)

"J@Y" wrote in message
...
I have this formula that uses MySheets as a list of sheets.


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

How would I name my sheets?