Find partial match in a cell
Closed
Wes
-
May 24, 2010 at 01:30 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - May 25, 2010 at 12:27 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - May 25, 2010 at 12:27 AM
Hello,
I want to do a "Match" or "Lookup" for a word in a cell. For example I have 1,000 company names. I want to label them into type of company. So for all the companies that have Mortgage or Loan in the name of the business, I want to enter in the next coulmn "Mortgage". So ABC Loan co., Best Loans, Title Mortgage, Loan Comapany of America - "Mortgage" Same for Accounting in the name - Accounting or any other industry.
Help!
I want to do a "Match" or "Lookup" for a word in a cell. For example I have 1,000 company names. I want to label them into type of company. So for all the companies that have Mortgage or Loan in the name of the business, I want to enter in the next coulmn "Mortgage". So ABC Loan co., Best Loans, Title Mortgage, Loan Comapany of America - "Mortgage" Same for Accounting in the name - Accounting or any other industry.
Help!
Related:
- Find partial match in a cell
- Music match jukebox - Download - Audio playback
- Based on the cell values in cells b77 ✓ - Excel Forum
- We couldn't find an account matching the login info you entered, but found an account that closely matches based on your login history. - Facebook Forum
- Excel function question - Excel Forum
- If cell contains partial text then return value in another cell ✓ - Excel Forum
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
May 25, 2010 at 12:27 AM
May 25, 2010 at 12:27 AM
suppose sample data is like this from A1 to A7
comp name
a loan co
b mortgage co
c metals co
d infotech co
e loan co
f mortgage co
in B2 copy this formula
=IF(AND(ISERROR(SEARCH("loan",A2)),ISERROR(SEARCH("mortgage",A2))),"","mortgage")
copy B2 down.
do you get what you want.
comp name
a loan co
b mortgage co
c metals co
d infotech co
e loan co
f mortgage co
in B2 copy this formula
=IF(AND(ISERROR(SEARCH("loan",A2)),ISERROR(SEARCH("mortgage",A2))),"","mortgage")
copy B2 down.
do you get what you want.