Forum Discussion
Linked drop down menu
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
