A combo box's autocomplete feature linked to a lookup function creates a flexible search tool.

How to Use Auto Complete in a Combo Box in Excel 2003. Excel offers tools and characteristics that make it an ideal platform for you to create data entry forms. One such feature is form controls ...