Drop Down List in Excel 2010 for exported contacts

We are looking to create a drop down list with excel that would contain our contacts in Outlook 2010.  I've exported to a .csv file and placed on Sheet2.  On sheet1 I chose the first column as the data source within the Data Validation section, but this just brings in the first name.

Say I have 100 contacts, I would like to hit the drop down list and choose their name, filling in the cell with relative contact information.

And if this is possible, is there a way to just pull it in from Outlook contacts via script or some other conenction?  

Who is Participating?
jppintoConnect With a Mentor Commented:
I've done something similar to what you would like to do. Please refer to the attached file to see an example. If you choose an article on cell B7, it will autofill the rest of the related cells on the same row with information regarding that article. If you want to see how this is done, the Validation Lists, please take a look at my EE article that explains how you can do it here:


Hope it helps.

You need to set the range of your data validation list to the range of your outlook contacts..

See picture,

The filling of the rest of the information is done using a VLOOKUP function, like you can see on cells from column E for instance.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.