ryanslundquist
New Member
- Joined
- Oct 9, 2014
- Messages
- 1
I have a list of companies that my company has in our customer relationship management software. This is column A. I have another list of companies that I have pulled off an online market place. This is column B.
I want to check if column A contains any of the companies that are in column B, even if it is only a partial match. For example, if the company name in column A is The North Face, but the company name in column B is North Face, then that should be considered a "current account." If the company in column B is NOT found in column A, then that should be considered a "net new company." Any ideas how to get this done? Thanks!
I want to check if column A contains any of the companies that are in column B, even if it is only a partial match. For example, if the company name in column A is The North Face, but the company name in column B is North Face, then that should be considered a "current account." If the company in column B is NOT found in column A, then that should be considered a "net new company." Any ideas how to get this done? Thanks!