Lookup_Validation

[kdoan]

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

[Marcelo]

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
>
>

[kdoan]

Marcelo,

Thansk for your respond. It works fine with the dropdown display id column. However, I want the drop down to display the description not the ID number. How do I get around it?
Thanks,
Khanh