11-09-2020 08:33 PM
11-09-2020 08:48 PM
I would create the list
go to the cell you want to create the dropdown list and select data validation from the Data tab in the ribbon.
Then in data validation select list and highlight the item names only.
then in the cell next to it use the vlookup function, it will search for the inputted value from the drop down list in your table and report the correct value
see the file