Hi, I have a vlookup cell to look up a list of 5500 items. Some times, users
may enter a wrong item and got nothing retunred. I am thinking of add a drop
down box for them to lookup the list in that case. However, 5.5K item is way
too much for the drop down. Does Excel have a function like Access that when
user enter first few characters, the drop down will show a list of items
have the same characters. How can I code that?
Thank you.
GL