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

This is the demonstration file referenced in How to combine Excel's VLOOKUP () function with a combo box for enhanced searching, by Susan Harkins.