Dependent Down Menus

[GIZDEEP]

How can I create a dependent drop down menu where I am able to enter a code and find all the descriptions that apply?


Example:

Code Description


Data:

Code Description

10030	CT Drainage Soft Tissue w/Guide
10030	IR Drainage Soft Tissue w/Guide
10030	US Drainage Soft Tissue w/Guide
10160	CT Abscess Drainage Lower Extremity
10160	CT Abscess Drainage Perineal

<tbody>
</tbody>

 

[DRSteele]

Welcome to the forum. And Merry Christmas.

Take a look at these links and see if they help. Dependent Drop-down Lists in Excel - EASY Excel Tutorial http://www.contextures.com/xlDataVal02.html

 

[GIZDEEP]

Thanks, but that didn't work--I don't get anything on the description. I only get the code drop down

 

[seekerarcane]

Create a separate Name range for code description and combine both Drop Down lists ( Code and Description lists) using INDIRECT, VLOOKUP functions for dependent list

 

[GIZDEEP]

I tried, but did not succeed. Can you please provide an example with the sample data listed above?