| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup_Validation
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup_Validation
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup_Validation
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 -- kdoan ------------------------------------------------------------------------ kdoan's Profile: http://www.excelforum.com/member.php...o&userid=34230 View this thread: http://www.excelforum.com/showthread...hreadid=562998 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
