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

Similar Threads

Vlookup and return sheet name also 2
Where best to place an instruction in a VBA script 4
Workbook sheet code delay 4
macro error - copying data twice 1
SUM VLOOKUP 1
VBA to create an Array of all Sheets in workbook 3
VBA: selecting sheets and copy them to a workbook 5
IF statement in Array Formula's 7

Top