match drop down list

[sick stigma]

Is there a way to start typing in a cell and have it return (in a drop down list) all matching values and have the list reduce is you type more?
Also, can a drop down list be made to show all, as opposed to useing a drag bar? See attached.
Thank you!