Drop Down with Description

[Escarabajo]

I am trying to figure out how I can have a drop down list to select from and have a description of the code I am selecting.

For example:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Code[/TD]
[TD]Description[/TD]
[/TR]
[TR]
[TD]1100[/TD]
[TD]Project Management[/TD]
[/TR]
[TR]
[TD]1200[/TD]
[TD]Project Coordination[/TD]
[/TR]
[TR]
[TD]1300[/TD]
[TD]Administration[/TD]
[/TR]
</tbody>[/TABLE]

Drop down only shows the code but no description. The code 1100 is the value I want to select but I will not always know what the code means without having to look it up.

Am I going about this in the wrong way, any help would be appreciated?

 

[Legacy 436357]

There must be a reference table with the matching descriptions. Different formulas can do this one in example would be index match.

Excel Workbook
	A	B
1	Code	Description
2	1100	Project Management
3	1200	Project Coordination
4	1300	Administration
Sheet2

 

[Escarabajo]

Not sure if I follow you. I have a cost breakdown structure and I need to add these codes to the associated costs. I can get a drop down in a single cell to provide the cost code but not with the description to choose the right cost code.

There must be a reference table with the matching descriptions. Different formulas can do this one in example would be index match.


Sheet2

	A	B

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:121.6px;"><col style="width:219.2px;"></colgroup><tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]1[/TD]
[TD="bgcolor: #666699"]Code[/TD]
[TD="bgcolor: #666699"]Description[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]1100[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]Project Management[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]3[/TD]
[TD="align: right"]1200[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]Project Coordination[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]4[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] , align: right"]1300[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffff]#ccffff[/URL] "]Administration[/TD]

</tbody>

Spreadsheet Formulas

Cell Formula B2 =IFERROR(INDEX(Sheet1!$B$2:$B$4,MATCH($A2,Sheet1!$A$2:$A$4,0)),"") B3 =IFERROR(INDEX(Sheet1!$B$2:$B$4,MATCH($A3,Sheet1!$A$2:$A$4,0)),"") B4 =IFERROR(INDEX(Sheet1!$B$2:$B$4,MATCH($A4,Sheet1!$A$2:$A$4,0)),"") <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

 

[Legacy 436357]

You can either pull the code by entering description or enter the code to get the description.

Which way do you prefer?

 

[Legacy 436357]

If you prefer to enter the description and the formulas to fill in the cost codes this will work:

Excel Workbook
	A	B
1	Code	Description
2	1100	Project Management
3	1200	Project Coordination
4	1300	Administration
Sheet2