You want to populate the combo box using the list in A1:A6 (on a sheet named LookupLists, which isn’t shown in the figure). The first step is to create a dynamic range for the list as follows: ...

Now, let’s use this function to create a unique list. How to create a unique list in Excel Microsoft Excel supports two different dropdowns: Data Validation and a combo box control.