Naming groups of named ranges

[wholesaleguy]

I have an large spreadsheet with 89 different named ranges that I want to use in an index formula with matches. Can I name a group of named ranges so that I don't have to reenter this data multiply times in the formula?

Thanks for your help!

 

[wholesaleguy]

sorry, I left a little of the formula out by mistake. should have been:

INDEX("ALL POSSIBLE REFERENCES SEPERATED BY A COMMA"),MATCH("DATA VALIDATION RESULT1","NAMED RANGE1",0),MATCH("DATA VALIDATION RESULT2","NAMED RANGE2",0),MATCH("DATA VALIDATION RESULT3","NAMED RANGE3",0))

 

[mikerickson]

If the ranges involved are not contigous and are seperated by commas, there is no way that INDEX will operate properly. INDEX only works on the first Area of a discontinous array, references to outside that Area gives a #REF error.