Okay, you got out of sequence I believe...

I did the following:
First cliced the cell
Second I pressed the drop down down arrow and without pressing enter key I
typed A but nothing happening.

1. First click on the cell...
2. Now without hitting ENTER type in the letter...
3. Now, while the cell is still in the edit mode, click on the drop down
arrow...
4. Should take you to the top of the list of the letter you typed in the
cell.

You pressed the arrow before you typed in the letter as I read your
response.

Regards,
Howard

" VLOOKUP fORMULA" wrote in
message ...
Any body help please,

I have a drop down box using data validation, it is a big drop down menue,
is there any way to select the name using typing the first letter and the
drop down menu show as per to that letter type.

for example if i typed u, show all names starts from u

pls help.
thanks