Hi, Kdoan,
on way is creating a colum before the code column and set a ID like, 1,2,3,etc
the drop down controls set a cell to return a number related the selection,
use a vlookup to find the 2nd column (id and code columns) to return the
correct code
hth
regards from Brazil
Marcelo
"kdoan" escreveu:
Hi,
I have 2 columns: Code and Description.
I created a drop down list allow users to select Description, How do I
display the code in cell instead of the description when users select
from the description list?
Thanks in advance!
Khanh
CODE ..................DESCRIPTION
C ..................Composite
CC ..................City Composite
CG ..................City Grab
G ..................Grab
IC ..................Industry Composite
IG ..................Industry Grab
LC ..................CSDLA Composite
LG ..................CSDLA Grab
OC ..................OCSD Composite
OG ..................OCSD Grab
UK ..................Unknown
--
kdoan
------------------------------------------------------------------------
kdoan's Profile: http://www.excelforum.com/member.php...o&userid=34230
View this thread: http://www.excelforum.com/showthread...hreadid=562998