Excel: show a detail of the selected item from a validation list on another cell?

In Excel, how can I set up my worksheet so that when I select a Company from a validation list of Companies it will show a detail of the business on another cell? Like the main business contact for example.

I've already created the validation list of companies (which links to a list on another sheet) and next to each company name I have the main contact. When the user selects a company from the dropdown list, I want the main contact to appear in next cell to the dropdown list. I'm not sure of the code to implement here...

Thanks for any help.
Dan

Use VLOOKUP

Regards