I am using Excel 2007 and have created a dropdown list from a very large list of data. But for some reason I cannot just type in the number so that it would automatically come up from the list. I have to use the scroll to find it.

Is there another way to create a list of some kind where I can just type the information into the cell and the closest matches would come up so I can pick them?