I've been trying to solve with a 2 column drop down. What I am hoping to do is use two columns to aid the user in selecting the correct entry. So the first column will be a number and the second column would contain what the number means
If:
Col1 | Col2
001 | Horse
002 | Cow
003 | Dog
Both columns show when the list is selected, but when the user selects 003 | Dog, the cell would be populated with only the 003.
I hope that makes sense, and thanks in advance for your assistance.
If:
Col1 | Col2
001 | Horse
002 | Cow
003 | Dog
Both columns show when the list is selected, but when the user selects 003 | Dog, the cell would be populated with only the 003.
I hope that makes sense, and thanks in advance for your assistance.
