Auto Complete Names

I want to enter a name in a cell from a list of Approximately 70 names I have on another work sheet by just typing the first few letters of the name into the cell I need it to complete the entry. I do not want to use a drop down box it takes too long to find the name. I need a formula to do this for my spread sheet. thanks

@ drwat or what other alias you use, please do not waste our time by double posting under various alias's.
Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: link to be added here

Is there a way to do this without a dropdown? Similar to the way google does it when you're typing in the search field?