25#Data Validation

  • Thread starter Thread starter RE: VLOOKUP fORMULA
  • Start date Start date
R

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
 
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
 
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"
 
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.
Click to expand...

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
 
Back
Top