Associating Range of data to drop down selection

[groitblat]

I'm trying to create a purchase order form that will list out the sizes based on a selected size range.
IE

Size Range Name is Children
Sizes within this scale are 2t, 3t, 4, 6x

Size Range Name 2 is Infant
Sizes within this scale are 0-3m, 3-6m, 6-12m

So when I select Children on the drop down I want the next column on same row to populate with 2t, then next cell 3t, then 5 then 6x...
Then if on the next row I select Infant on the drop down the sizes that would show up would be 0-3m, 3-6m, 6-12m
Vlookup or Hlookup seem they'd work IF I only had 1 size scale or if I nested a gazillion if statements but I'm hoping that there's a better (less cumbersome) solution that I'm not stumbling upon.

Thanks for any suggestion/tips in advance.

 

[SkipVought]

Hi,

You need all this data in one table.

You don't have a 2 size, you have 2t. It must be consistent.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]