Auto complete
 

Hello
was wondering if anyone could please help me out with this problem I'm having.

I have a product list in sheet 1

A B C
Names price quantity

What i would like to do is when I type a name in sheet 2 column A I would
like it to auto complete it or give me a list for example If i start to type
Flour it would give me a drop down so i could select a specific type of flour
(flour corn....flour bakers). the only problem I'm having is my product list
is over 5000 items so it would have to filter through heaps of data....is
this possible.

Thanks
Ian