coffeeman12
New Member
- Joined
- Sep 19, 2020
- Messages
- 8
- Office Version
- 2016
- Platform
- MacOS
Hard to articulate in a subject line. The examples I've found so far all use Scripting Dictionary, which doesn't work on a Mac. I'm on Mac Excel 16.16.27.
I have two data sheets:
Sheet1 is a list of names (from a particular data set) in column A.
Sheet2 is another list of names (also column A), which should include all the names in Sheet1, and probably more. Sheet2 has email addresses in columns C and D. For some reason this data set includes a "confidential email" and a regular email address. For some names, both will have entries, for other names there will be only one entry.
I'd like Excel to match names from sheet1 to the names in sheet2, and when matched, copy the cells in columns C and D to the same columns in sheet1.
I have two data sheets:
Sheet1 is a list of names (from a particular data set) in column A.
Sheet2 is another list of names (also column A), which should include all the names in Sheet1, and probably more. Sheet2 has email addresses in columns C and D. For some reason this data set includes a "confidential email" and a regular email address. For some names, both will have entries, for other names there will be only one entry.
I'd like Excel to match names from sheet1 to the names in sheet2, and when matched, copy the cells in columns C and D to the same columns in sheet1.