Hi,
I have a file to map from a different excel file. The common field in both files is the email address, however, some cells have more than one email address. Below is the sample data and here's what I need to get:
Is to fill column F with the right team from columns A & B, and if there's more than one email i.e. F6, then the result is to update the cell with both team names, there maybe a situation where more than one email belong to the same team. is there any good formula for such situation?
I have a file to map from a different excel file. The common field in both files is the email address, however, some cells have more than one email address. Below is the sample data and here's what I need to get:
Is to fill column F with the right team from columns A & B, and if there's more than one email i.e. F6, then the result is to update the cell with both team names, there maybe a situation where more than one email belong to the same team. is there any good formula for such situation?
| Book1 | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | |||
| 1 | Mapping Table | Desired Results | |||||||
| 2 | Team | Team | |||||||
| 3 | a@abc.com | AAA | a@abc.com | AAA | |||||
| 4 | b@abc.com | BBB | b@abc.com | BBB | |||||
| 5 | c@abc.com | BBB | c@abc.com | BBB | |||||
| 6 | d@abc.com | BBB | a@abc.com b@abc.com | AAA, BBB | |||||
| 7 | e@abc.com | AAA | d@abc.com | ||||||
| 8 | f@abc.com | AAA | a@abc.com f@abc.com | AAA | |||||
| 9 | g@abc.com | BBB | e@abc.com | ||||||
| 10 | d@abc.com e@abc.com | BBB, AAA | |||||||
| 11 | f@abc.com | ||||||||
| 12 | g@abc.com | ||||||||
| 13 | |||||||||
Sheet1 | |||||||||
