Hello.
I have a drop down menu pulling from another sheet of inventory items. The issue is that there are so many items that it is somewhat difficult to find the right one quickly on the dropdown. Is there a way to get the field to start filling out the item as I type? However, to make it more complicated if the user is looking for gloves they will likely start typing g l o v and wont find anything because the gloves are written "green medium winter gloves" etc. on the inventory list. Is there a way to do this, in other words make it search inside the cell for matching words?
Thanks so much.
Bookmarks