25#Data Validation

[RE: VLOOKUP fORMULA]

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

 

[L. Howard Kittle]

Sort your validation list and at the beginning of the A's enter a single A,
do the same for the beginning of the B's and all the way through to the Z's.

Click in the cell that has the drop down validation and type in the letter
of the list you desire... say you type in an O. DO NOT hit enter... leave
the cell in the edit mode (still selected) and now hit your down arrow.

Should take you to the O which is the top of the O list of selections.

HTH
Regards,
Howard

 

[RE: VLOOKUP fORMULA]

I tried that way but an error message is poping up

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.


"The value you entered is not valid"
"The user has restricted values that can be entered into this cell"

 

[L. Howard Kittle]

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

 

[Ashish Mathur]

Hi,

You may want to see question 44 of http://ashishmathur.com/replies.aspx

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com