When you create a dropdown list using a range, each item within that range will be used as the option value. So if you use a range that includes 5 cells, then you will end up with 5 different options.

With dynamic arrays, your drop-down list will always reflect the latest changes without any manual intervention. This means you can focus on your data, not on updating lists. Using Excel Table ...