I'm looking to use the data validation tool. I'd like user to choose cell value from a very long list. Instead of have to click on the dropdown and scroll to value, how can I have them start typing and have excel auto populate value from list? I'd like to keep the function as simple as possible to prevent issues. Thanks!