How to get data validation to automatically drop down a list and sort through it.

Hi,
I am looking for a way to optimize data validation so that when I am typing in a word, it brings down a list of the words I have used, and as I am typing it brings up the most related word to what I have typed so far. Kind of like autocomplete, but with a drop down list that brings up the most similar word. So for example, if I type "Fund" in a cell, the list will drop down, and it will say "Fund A, Fund B, Fund C, Fund D" and any other "Funds" Then I could select one of them and it would fill it in for me. The reason why I want to do this is because I have many different funds I need to enter into a spreadsheet and they are all very similar except for a few minor differences. So autocomplete does not work because all the words are not recognized until I am done typing them. Any help would be very appreciated as this project is extremely crucial to me.

EDIT: So to sum things up, I want a way for autocomplete to have a drop down list that I can select similar words from, or something along those lines.

It would be nice to have that option in many situations but I'm sure that its not possible, the autocomplete that excel provides is the best you will get.

Heres hoping someone will post after this with a solution though!