koppahollic
New Member
- Joined
- Oct 26, 2020
- Messages
- 8
- Office Version
- 2013
- Platform
- Windows
Hi there. I'd appreciate any insight into the issue i'm running into outlined below. thanks.
Scenario: I have 2 files both with the same unique user id. I want to import file 2 to update my CRM because it has additional data values. I need to match the files on the user id but i can't figure out how craft a formula when the vlookup matches on the user id to also pull the corresponding email address with it in a new column from file 1 into file 2.
File 1 data columns
Scenario: I have 2 files both with the same unique user id. I want to import file 2 to update my CRM because it has additional data values. I need to match the files on the user id but i can't figure out how craft a formula when the vlookup matches on the user id to also pull the corresponding email address with it in a new column from file 1 into file 2.
File 1 data columns
- user id (column a)
- email address (column b)
- user id (column a)
- multiple columns with additional data but no email address