Excel：Drop-down List Based On Selection In Another Drop Down List
February 3rd, 2011
No comments
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)
Recent Comments