Linked drop down menu

%3CLINGO-SUB%20id%3D%22lingo-sub-1870197%22%20slang%3D%22en-US%22%3ELinked%20drop%20down%20menu%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1870197%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20need%20to%20create%20a%20drop%20down%20linked%20to%20values.%20So%20I%20select%20an%20item%20on%20the%20list%20and%20the%20cell%20next%20to%20it%20reflects%20the%20value%20of%20that%20item.%20Does%20anyone%20have%20an%20instruction%20on%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1870197%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1870215%22%20slang%3D%22en-US%22%3ERe%3A%20Linked%20drop%20down%20menu%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1870215%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F863457%22%20target%3D%22_blank%22%3E%40JoeWest%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20create%20the%20list%3C%2FP%3E%3CP%3Ego%20to%20the%20cell%20you%20want%20to%20create%20the%20dropdown%20list%20and%20select%20data%20validation%20from%20the%20Data%20tab%20in%20the%20ribbon.%3C%2FP%3E%3CP%3EThen%20in%20data%20validation%20select%20list%20and%20highlight%20the%20item%20names%20only.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethen%20in%20the%20cell%20next%20to%20it%20use%20the%20vlookup%20function%2C%20it%20will%20search%20for%20the%20inputted%20value%20from%20the%20drop%20down%20list%20in%20your%20table%20and%20report%20the%20correct%20value%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Esee%20the%20file%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1870237%22%20slang%3D%22en-US%22%3ERe%3A%20Linked%20drop%20down%20menu%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1870237%22%20slang%3D%22en-US%22%3EThank%20you%3C%2FLINGO-BODY%3E
Highlighted
New 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
Highlighted

@JoeWest 

 

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

Highlighted
Thank you