Question: how to get dropdown value in excel?
Answer: In a new worksheet, type the entries you want to appear in your drop-down list. ... 
Select the cell in the worksheet where you want the drop-down list.
Go to the Data tab on the Ribbon, then Data Validation. ... 
On the Settings tab, in the Allow box, click List.
Click in the Source box, then select your list range.