There are a few ways to create a drop-down list in Excel. The first way is to create a list of items in a column, and then use Data Validation to create the drop-down list. The second way is to use a data validation list in a cell, and then refer to that cell in another cell.

To create a drop-down list in a column, first create a list of items in a column. In the example below, the items in the drop-down list are in the column "Item".

Next, use Data Validation to create the drop-down list. In the example below, the Data Validation is in the column "Choice".

To create a drop-down list in a cell, first create a list of items in a cell. In the example below, the items in the drop-down list are in the cell "A1".

Next, use Data Validation to create the drop-down list. In the example below, the Data Validation is in the cell "B1".

To refer to a data validation list in another cell, use the following formula:

=INDIRECT("A1")

In the example below, the drop-down list in cell "B1" is referring to the list in cell "A1".