I have assigned cell A1 to have a validation List. It references another sheet with all of my customer names, addresses and contact information.

When I choose one of the names from the drop-down list in A1. I want cells A2, A3,A4 to populate with the corresponding contact information for that customer. Can this be done?