How to name a sheet list


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?
 
Ad

Advertisements

B

Bob Phillips

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)
 
Ad

Advertisements

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top