Is there a way to search a drop down list using certain key words, ie context sensitive search?
I have a sheet (Sheet A) that has a unique list of Part Names and Part Numbers. In a second sheet (Sheet B) i have two corresponding columns for Part Name and Part Number. Part Name has a drop down list for the user to pick a part name and the part number is auto populated. This works with no issues.
However, we have a lot of parts and I would like the user to have the ability to enter key words which would then filter and present a list of Part Names for the user to select. Today, the user needs the EXACT name to find the part name.
As an example:
Sheet A has the following Part Numbers and Part Names
111111 Engine Cooling Fan
222222 Auxiliary Fan Assembly
333333 Dynamic Friction Brake Pads
If the user types "fan" in Sheet B's (Part Name) drop down list, i would like the first two parts to be displayed.
Thanks in advance!
Help Article Resources
Check out the Formula Handbook template!