Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2021/06/IF-Drop-Down.xlsx

In this video I demonstrate how to create a drop-down list in Excel that includes an IF Statement. The IF statement allows you to display one of two lists in a single drop-down.

In our scenario, we have two wedding lists that we want to display in a single drop-down. By default, the drop-down displays a short list but gives the option to switch to a longer list.
------------------------