Hi, I would like to create a conditional list I have a list of data on sheet2:


Company Name Size
AAA Apple 1 lbs
BBB Banana 2 lbs
AAA Strawberry 1 lbs
DDD Apple 2 lbs
CCC ETC etc
DDD ETC etc
AAA ETC etc

I want three list in sheet 1:

First list is the company:

Second list is the name if the company is the one selected in the previous list

The third the QTC if the name is selected (Best if the name and company but not necessary).

How could I do it?

Thank you