Drop down list from another excel that contains some word in the english language?


Hi is it possible to create drop down list that contains some word in the english language? possibly linking to a from another excel the one built into office 2007/10...

I would like to be able to start typing a word in the cell and it starts to show the drop down list of all the matching words as I enter the keys and once I see the correct word I can select it?