auto complete look up fields Access or Excell?

I have a set of data that is very easily controled in Excell. It contains names, ID numbers, car numbers and so on. I need to create a simple form with all of the same fields. When the user starts typing in the name field I want the form to auto fill the name field with names contained in the list. When they tab out of the name field the form will fill in all of the remaining fields according to data contained in the spredsheat. I know how to make the second part of this form work, it is the auto complete part I am having trouble with.

Is it possible to create a form to do what I have described? If so, which Office application should I use, and how do I make it work?

As a last resort I could use a drop down field, but the list of names is over 200 long.

Thank you for any and all advice on this topic.