ok. i ran into a problem. i need to be able to have more than one =indirect reference. for example. "PetiteSize" under shorts (sheetname "shorts") can be for:
P0
P1
P2
P3
P4

but i also have "PetiteSize" for shirts (sheetname "shirts") and will be used for:
P3
P4
P5
P6
P7
P8

Now the dumb thing about this is that I can't reference it to another sheetname which is pretty frustrating. I'd be able to seperate everything by sheetname, but I can't so how do I have the dropdown menu be available only for P0 to P4 only when I'm doing shorts and P3 to P8 only for shirts? They use the same "PetiteSize" and I have to have that exact name or it wont work.