I don't think I am explaining my issue correctly in the title, or I think it will be confusing if I did.
I have a dropdown box (data validation) with many options to select from. What I want to know is that if it's possible to have the dropdown box give me suggested options after typing the first letter/first few letters. Pretty much like any search out there like google.
Here's an example of what I mean just to clarify:
My list in my drop down consists of: "Apple", "Apricot", "Banana", "Blueberry", "Kiwi", and "Plum"
Now in the drop down, I type "A" it suggests that I want to select "Apple" or if I keep typing and type "Apr" it suggests I want to select "Apricot"
Another example: In the drop down I type "P" it suggests that I want to select "Plum"
Not sure if this is actually possible, but I figured i'd ask. I hope this explanation has been clear enough for others to understand.
Bookmarks