See example:

-You type first letter
-Click on drop down list

http://boisgontierjacques.free.fr/fi...stLetters..xls

=Offset(Noms,Match(A2&"*",Noms,0)-1,,Countif(Noms,A2&"*"))

JB
http://boisgontierjacques.free.fr

On 23 avr, 17:37, Rita wrote:
I have created a drop down list. *Is there any way to start typing a letter
in the cell and the corresponding choices appear, instead of scrolling down
the list? * If so, is it possible to have both the scroll option and the type
a letter option, not just one or the other? * Thank you.