BrettOlbrys1
Board Regular
- Joined
- May 1, 2018
- Messages
- 138
- Office Version
- 365
- Platform
- Windows
- Column A: list of 1,000 employee IDs
- Column B: list of job descriptions
I want to only return the list of employee IDs (from column A) that have a partial match in column B.
The matching words would be "North", "South", "West", "Central"
Using the sample data below, E564, E1, and E88 would be excluded, and the resulting list will be everyone else.
What formula is needed to accomplish this?
Sample Data:
- Column B: list of job descriptions
I want to only return the list of employee IDs (from column A) that have a partial match in column B.
The matching words would be "North", "South", "West", "Central"
Using the sample data below, E564, E1, and E88 would be excluded, and the resulting list will be everyone else.
What formula is needed to accomplish this?
Sample Data:
Column A | Column B |
E967 | Northeast Sales |
E23 | Southwest Sales |
E564 | Project Manager |
E888 | West Sales |
E234 | West Sales |
E1 | President |
E88 | Project Manager |
E478 | Central Tech |
E99 | Southeast PM |