ComboBox autofill

[SPARKY347]

hey everyone ive created a sheet adding and searching materials, works awesome so far just trying to make adjustments. when I search something I can type in either combo box problem is to search I have to start with the first word to get the combo box to auto complete ex. "single" will produce "single gang ressy box". is there any way to maybe search "gang" and have it produce the full string or any match of the string and I can narrow from there