Linked drop down menu

Copper Contributor

Hi, I need to create a drop down linked to values. So I select an item on the list and the cell next to it reflects the value of that item. Does anyone have an instruction on this?


2 Replies



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

Thank you