Question: how to get dropdown selected value in excel?
Answer: Create your list with matching values.
On the Data tab choose Data Validation.
The Data validation form will be displayed.
Set the Allow dropdown to List.
Set the Source range to the first part of your list.
Click on OK (User messages can be added if required)