Drop Down List with "Find" function

Hi all Excel experts.

I have created a drop down list but I find it too difficulty to find the drop down list, when I have about 1000++ product code in the drop down list.
Is there anyway that I can have the "find" function, just like how we have in Excel?
With that, it would be easier to search the product code, instead of scroll up and down where the product code might have been not in sequence inside the 1000++ list.
If possible, try not to involve macro as I'm not strong using macro, but if that's the only option, I'm willing to learn.

Appreciate all the help.

Regards
cks1026

Hi SamboKid,

I don't understand, can you elaborate more?
Reason why I use DD is because that DD on that particular cell will be used for graph presentation, hence using DD will tidy up the list of product code, in a way it hidden the codes, and find as of what I need to look at, which is the most troublesome.

Hi FDibbins,
The things is it's a product code, it's not a description, can it be done?

Thanks both of helping out..

ComboBox. See the excel help on how to create/use those is there a link to this ?

Here is a link that may be of some use. You an create a searchable drop down list. Its all done with formulas, no VBA.

HTML Code: 

Jim O

Thanks JO505

Your welcome.

Jim O