I produce a weekly document, like a work roster, that I need to put a employees name, phone number and email in. What I was wondering is if it would be possible to have this auto populated from a list. For instance, I have a list that has JOE BLOGGS 0410 999 888 joe.bloggs@net.com. I want to be able to in cell B2 choose JOE BLOGGS and have his phone number go into cell C2 and Email in D2.

Is this possible?