mitchman7614
New Member
- Joined
- Apr 25, 2006
- Messages
- 29
I've got a download of data that includes a bunch of customer names. I want to add the account leader, manager, and generic customer name to group them together. Further clarity is below:
Sheet 1 (Columns)
Customer Name
Generic Customer Name (to be mapped)
Account Leader (to be mapped)
Account Manager (to be mapped)
product
Sheet 2 (Columns)
Customer Name (same as sheet 1)
Generic Customer Name (I populated - this is fixed and generally does not change)
Account Leader (I populated - this is fixed and generally does not change)
Account Manager (I populated - this is fixed and generally does not change)
How can I pull in the data from sheet 2 into sheet one? I tried a SUMIF, but get a 0. Any help here is much appreciated.
Sheet 1 (Columns)
Customer Name
Generic Customer Name (to be mapped)
Account Leader (to be mapped)
Account Manager (to be mapped)
product
Sheet 2 (Columns)
Customer Name (same as sheet 1)
Generic Customer Name (I populated - this is fixed and generally does not change)
Account Leader (I populated - this is fixed and generally does not change)
Account Manager (I populated - this is fixed and generally does not change)
How can I pull in the data from sheet 2 into sheet one? I tried a SUMIF, but get a 0. Any help here is much appreciated.