adding multiple columns of data to a sheet via vlookup

[jjastreetpress]

HI. I'm hoping someone can assist me. I have two excel docs. One is a list of Account Cancellations from the Finance system. The other is a full Account list with Contact information . I need to get the the finance data onto the full Account list with Contacts so that someone can followup with cancellations. The column they have in common is the Account Name. How can I (it is possible to) pull over the 28 columns that are on the finance spreadsheet to the Account and contact list?

Thanks.

 

[rgs694]

Could you give a sample of the various data lists?

 

[Chris Macro]

This Vlookup Intro might give you a good overview of how you can do this. But like rgs694 said, it would be helpful to get some sample data.

 

[hiker95]

jjastreetpress,

Welcome to the MrExcel forum.

What version of Excel and Windows are you using?

Are you using a PC or a Mac?

Can you post screenshots of the 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:
Excel Jeanie
MrExcel.com | Excel Resources | Excel Seminars | Excel Products

Or, when using Internet Explorer, just put borders around your data in Excel and copy those cells into your post.
See reply #2 the BLUE text in the following link:
http://www.mrexcel.com/forum/about-board/444901-how-create-table-like-aladin.html#post2198045


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.

 

[jjastreetpress]

HI. I'm hoping someone can assist me. I have two excel docs. One is a list of Account Cancellations from the Finance system. The other is a full Account list with Contact information . I need to get the the finance data onto the full Account list with Contacts so that someone can followup with cancellations. The column they have in common is the Account Name. How can I (it is possible to) pull over the 28 columns that are on the finance spreadsheet to the Account and contact list?

Thanks.

Upon further investigation I don't have a match for the Account Name. Some are spelled differently in the finance system versus SF. Thank you all for your responses, but I'll have to find another field to match.

 

[Chris Macro]

Good luck!

 

[hiker95]

jjastreetpress,

Thanks for the feedback.

I'll have to find another field to match.

When you do, we will be here to try and find a solution for you.