Creating a Dropdown that is Related to the Value Given in Another Cell

I am looking to create a drop down menu.

So image in this... in cell C will be drop down menu that is related to the the value of what the drop down menu in cell A is. It may be an appliance such as a Dishwasher or whatever the particular appliance might be that is being inspected in an home. Then, when the appliance is selected in the cell A drop down, the options in the Drop down Menu in cell C will have the corresponding options that are related specifically to that particular appliance.

So basically if cell A = Dishwasher then the drop down menu in cell C should reference all the options that are Dishwasher related

And if Cell A = Water Heater then the drop Down Menu in cell C should reference all the options that are Water Heater Related

And….so on…

I have searched for a solution and nothing matches my scenario perfectly. Help!

G'day and welcome back to the forum,

Try this http://www.contextures.com/xlDataVal02.html