SytelineMaster

How to get a 2nd drop down box to update the range (Not just use C6:C7)based on selection in 1st drop down box. Example: If Fat, Use range from C6:C7 If Skinny, Use range from D6:D7 You can direct put the IF statement in 2nd drop down validation, like =IF(Sheet1!$A$1="Fat", Sheet1!$C$6:$C$7, Sheet1!$D$6:$D$7)