I have a two column lookup table with the column names EquipmentType and EquipmentSubType The EquipmentType column contains entries like "AIR CONDITIONER" and "VEHICLE". The corresponding values in the EquipmentSubType column are "WINDOW AIR CONDITIONER" and "ROOFTOP AIR CONDITIONER" for "AIR CONDITIONER" and "PANEL TRUCK" and "SCHOOL BUS" for "VEHICLE". In my main worksheet, I have a table with the same column names which validate on the corresponding columns in the lookup table. What I need is the EquipmentSubType selection to show only the values corresponding to those selected for the EquipmentType. If "VEHICLE" is selected, the EquipmentSubType validation list should only have "PANEL TRUCK" and "SCHOOL BUS" in the validation selection. What I get now is the entire list, "WINDOW AIR CONDITIONER", "ROOFTOP AIR CONDITIONER", "PANEL TRUCK", and "SCHOOL BUS"
How can I make the validation selection list show only Sub Types corresponding to the selected Type
How can I make the validation selection list show only Sub Types corresponding to the selected Type