I have a list of 6 items that can be selected from a validation list in cell A1. Here are the options for A1: Air Compressor,Air Stripper,Catox,MPX Blower,SVE Blower,Thermox.
If I select "Air Compressor" in A1, I want the validation list in B1 to be: Rotary screw, Vane, Claw, Regenerative
If I select "Air Stripper" in A1, I want the validation list in B1 to be: Tray, Tower, Diffuser.
and so for the other 4 A1 options.