I have a work project in which I am required to produce a list of peoples names with the accompanying email addresses and phone numbers. Sounds easy enough except for the fact the person who designed our Corporate database did so in an awful way so rather than be able to do so in Business Objects, I have to pull a list of names with email addresses first then seperately pull one with names and phone numbers. As part of this project, a list that has name, email and phone number in one row is required.
Is there a formula where I can match based on the first/last name of a person then bring over their email address/phone number from the next sheet? In the sample I have one sheet with the names and phone numbers then another with the names and addresses. How do I produce a single row that has both? I seem stuck as my Excel skills are lacking in this regard.
As a note there may not always be a match as in some cases someone with a phone number may not have an email address or vice versa, which is fine. In these cases where they do I need to show that though. I hope I was clear enough...
Bookmarks