The list in the second drop-down list will change accordingly.Select the food type in the top drop-down list.Once again, we are using Range Names in the formula. Select List from the Allow drop-down list, and then type the following formula.In the Ribbon,, select Data > Data Tools > Data Validation.Select List from the Allow drop-down list, and then select Range F2:I2.The list will have changed to show the meat list while the top value will have change to “Show Fruit.”Ĭreate a Custom Drop-down List with a Nested IF Statement in ExcelĮxpand on the formula above by using nested If statements. Click on “Show Meat,” and then click on the drop-down list again.Click on the drop-down list to see the list of available fruit.Depending on the option chosen, the corresponding list will show up in the drop-down list. you are welcome if Excel 2016 is your default version - update profile - will be easier for you and for us If that takes care of your original question, & to say Thanks, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you) then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED. The formula uses two range names – ShowFruit and ShowMeat.
=IF(C2="Show Fruit", ShowMeat, ShowFruit) Select List from the Allow drop-down box, and then type the following formula:.In the Ribbon, select Data > Data Tools > Data Validation.To create a drop-down list which changes according to what the user selects, you can use an IF statement within the data validation feature. This tutorial will demonstrate you how to create a drop-down list with an IF statement in Excel and Google Sheets.Ĭreate a Custom Drop-down List with Data Validation in Excel
0 kommentar(er)
