So I've created a list of products. I'd like to be able to start typing in
the name of the product, and the list automatically go down to where that
product is located on the list.

Currently, if you click in the cell that contains the list, you're able to
type the product name, but it's entering the name as if you were trying to
enter the name in the cell, and not select it from the drop-down menu. Once
you hit "enter", it says the value is invalid.

Know any way to type to be able to scroll down the menu?