I have a list of contacts that I often enter into the same table in excel.
The name, address, post code and telephone number are in seperate cells. Can
anyone show me a way of automatically completing the rest of the contact
information after I enter their name in another cell? I tried creating a
lookup table but I'm not really sure how to automate the process. Any help
would be wonderful!

Thanks,

Miguel