Adjusted drop down list

Hi,
I have a list of 1,000 ID's (Range: "A1:A1000").
I need a user to choose ONE id from a drop down list which based on the said range.
Any chance this drop down list could "jump" the user to the 900's area if the user press just "9"?
*Since the user is a little bit unfamiliar with Excel it be better if it could be done without VBA"
Thanks

What are you using for a drop down list? From my playing around, it doesn't seem to work for data validation or for a form control combo box, but it does work for an Active-X combo box.

*Since the user is a little bit unfamiliar with Excel it be better if it could be done without VBA"
Thanks

Regular data validation/DropDown wont let you do this, you will need something with VBA behind it.

a 1000-item-long list is a lot to choose from. Can that be broken down into categories at all?

Thanks for both of you.

@Ford, unfortunately VBA is not an option this time.

And if DropDown list does not enabe auto completion, then data will be entered manually into the DropDown list and at least I'll use the built in validation of it.

Please see the sample.

You haven't answered why you couldn't use an Active-X combo box. VBA has nothing to do with what you need. Am I missing something?

@natefarm - sorry, thanks a lot it works!

Please check the file i have there a question how to refer to the value in the combo, i need it to a vlookup function

That's a form control combo box, not an Active-X. Active-X will allow you to begin typing, and it will jump to that number, which is what I thought you wanted.

I should have said that the entered number (ID) into the combo is later used within a vlookup function.

**Correction - the "jump" is not possible with the non Active X**

I'm trying now the Active X option..

@natefarm - how do I populate an Active X combo without using code?