Multiple Column drop down list

[jaydeepvyas2005]

I have a issue 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:
Column 1 | Column 2
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

 

[Asheesh]

hi,

Can you share the sample file with the expected output...it will be easier for members to solve your query...

 

[jaydeepvyas2005]

Please find attached file for your reference

 

[NARAYANK991]

Hi ,

A similar question has been asked earlier here :

http://chandoo.org/forum/threads/drop-down-list-help-abbreviated-in-cell-but-longer-in-list.27568/

See if the link posted by Jeffrey Weir helps.

Narayan

 

[jaydeepvyas2005]

Ok, Thanks for solution
But is it possible with formula only without macro.