Need data to show by selecting a category in a drop down list

So i am creating a purchase order template for my company. It requires departments, categories and size scales. I am able to make the drop down list for departments and categories (catg. tied to departments, so that it shows only categ of selected dept).

But the size scales, I want to show them in a row, but not all of them. Only by the size scale that I pick in a drop down. For example:

SCALE TYPE
MENS SHIRTS S M L XL 2XL 3XL 4XL
KIDS SHIRTS 2T 3T 4T 4 5 6 7
CAPS OSFA

So the scale will be picked in a drop down list, and then the row of that scale should show ahead of it...

I know I need to use indirect func, but I cant exactly make it work. Any help would be great!! thanks in advance

Pl attach a sample dummy file showing Expected results.

Thank you so much! it worked exactly how i wanted it... thanks again!

Hi again,

I was trying t replicate the formula you gave me earlier but its not working on the template im working on.. I was wondering if you
could give it a shot? I've highlighted the region where i need the scale to appear.. also, to the far left, at column "AH" is the data I need... I've already created the drop down lists. please help me out with this... not sure why its not working... thanks in advance

worked totally fine! everything i needed... thanks again! post is solved