Predicting text from a list

Hi

I was hoping someone could help me with a predictive issue.

from the attached spreadhseet, you can see that sheet1 has a list of football teams... In sheet2 cell B4 i want to type in a team name (that will exist in the list)..... what i need excel to do is prompt the user for the team, based on what they have typed in.

EXAMPLE

User keys in 'Ev'... This would result in 'Everton' being suggested to the user.

I remember seeing this on a spreadsheet years ago..... It would really help me out if i could make this work for me.

Any help greatly appreciated.
text prediction example.xlsx

Thanks for that......were really getting somewhere here

i do have a bit o fa hurdle with it though..... the combo box works,apart from when i link it to a cell, the result is showing the number of the date, rather than the content.

You can see from sheet 2 that the combo box is linked to cell B3. Cell B3 is being used by a formula in C5.

I need cell C3 to show what is in the combo box.

Any ideas?

text prediction example2.xlsx