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

[groovingirl13]

I am looking to create a drop down menu in cell C will be related to the the value on the drop down menu in Cell A is Dishwasher or whatever the appliance might be that the options in Dropdown Menu in cell C will have the corresponding options that are related specifically to Dishwashers, or Water Heater or Dryer, etc…

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!

 

[hiker95]

groovingirl13,

Welcome to the MrExcel forum.

See:

Excel -- Data Validation -- Create Dependent Lists
Excel Data Validation -- Dependent Lists


Excel Data Validation
Excel Data Validation Tips and Quirks
Excel Data Validation - Add New Items