Merging two excel sheets

[jayblatherwick]

I have 2 excel sheets, both are csv files. I imported one from Outlook with names, emails and telephone no's, the other was from access with names and addresses. I want to merge them. The problem is there are some of the same names in both but not all. I want to be able to match the info of the same name entries together from both files rather than having 2 line entries both with the same name, but one with the address and the other with email info. Please help anyone!

 

[hiker95]

jayblatherwick,

Welcome to the MrExcel forum.

1. What version of Excel and Windows are you using?

2. Are you using a PC or a Mac?


Can you post screenshots of the two actual raw data worksheets?

And, can you post a screenshot of the worksheet results (manually formatted by you) that you are looking for?

To post your data, you can download and install one of the following two programs:
1. MrExcel HTMLMaker20101230
https://onedrive.live.com/?cid=8cffdec0ce27e813&sc=documents&id=8CFFDEC0CE27E813!189

Installation instructions here:
http://www.mrexcel.com/forum/board-announcements/515787-forum-posting-guidelines.html#post2545970

2. Excel Jeanie
Download


If you are not able to give us screenshots:
You can upload your workbook to Box Net,
sensitive data changed
mark the workbook for sharing
and provide us with a link to your workbook.