Data Validation W/ Auto Complete

Is it possible to have Data Validation set up so that the person can type into the cell and have the text auto complete based on the range that the DV is pulling from?

I'm making a sheet and the range I want to pull from has 500+ values. I can't sit and wait for the list to scroll it takes FOREVER I and am trying to find a solution.

I've found a bunch of threads on other excel forums but they all either lead to a dead end (probably because the writer was on a PC) or the solution just didn't work.

Any ideas?

 

Anyone? This has been a tough problem to solve.