| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to link a list or range of cells to another sheet in same workbook | Excel Discussion (Misc queries) | |||
| Data from two sheets make up real time list in the new sheet?? | Excel Worksheet Functions | |||
| Returning Values | Excel Discussion (Misc queries) | |||
| Sum up columns in different sheet with error check | Excel Discussion (Misc queries) | |||
| Selection from list on main sheet from suplemental sheet in same w | New Users to Excel | |||
Hybrid Mode
