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:

Code	Description
1100	Project Management
1200	Project Coordination
1300	Administration

<tbody>
</tbody>

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
1	Code	Description
2	1100	Project Management
3	1200	Project Coordination
4	1300	Administration

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:121.6px;"><col style="width:219.2px;"></colgroup><tbody>
</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