There is no formula for autocomplete.............just internal programming
by Excel developers.

See help on ComboBox which will contain your list of values and supports
autocomplete.


Gord Dibben MS Excel MVP

On Fri, 13 Nov 2009 13:54:01 -0800, Ryan
wrote:

I have a list of 1000s of items and i want the same formula that was used to
make the formula autocomplete. I want to start typing and a list drops down
of all the avaliable options. Like if in my list is apple and appricot i
want to type a and both of them appear in a list. It is for my squadron
commander and i cant figure it out. Any help is much appreciated.