Drop down list with a different output than input

cburke996

New Member
Joined
Dec 12, 2013
Messages
1
Hi all - I am wondering if there is a way to create a dropdown list that outputs a different value than what the input was.

For example, I want the dropdown list to contain full words (Machined, Bought, Assembled ect...) and when you click those words, it outputs a code based on the word (M, B, A ect...). Can I do this?

Thanks,
Connor
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

BrianMH

Well-known Member
Joined
Mar 26, 2008
Messages
1,490
Yes. Make it a multicolumn drop down bound to the first column. Make the first column width = 0 so it doesn't show. Now only the second column will show but the output will be that of the bound column.
 

Watch MrExcel Video

Forum statistics

Threads
1,095,817
Messages
5,446,673
Members
405,413
Latest member
AlainCar

This Week's Hot Topics

Top