I need a formula that will assess data in column A and the set Column B to one of the following:
Growth
Portal
Analyics
GRC
Logic
If Column A begins with ProductDev-Growth set Column C to Growth
If Column A begins with ProductDev-Compliance set Column C to GRC
If Column A begins with ProductDev-Portal set Column C to Portal
If Column A ends with Connector set Column C to Analytics
If Column A begins with ProductDev-Portal-Analytics set Column C to Analytics
Here is what could be in Column A below:
Professional Services-Managed Services
ProductDev-Management
Customer Success
ProductDev-Growth-Salesforce Connector
Professional Services-Managed Services
Professional Services-Managed Services
Professional Services-Managed Services
Customer Success
Customer Success
Professional Services-Managed Services
Customer Success
Customer Success
Professional Services-Managed Services
Customer Success
Professional Services-Managed Services
Customer Success
Customer Success
ProductDev-Portal-Analytics
ProductDev-Growth-Microsoft Sales App
ProductDev-Growth-Microsoft Connector
ProductDev-Growth-Salesforce Sales App
ProductDev-Growth-Salesforce Connector
ProductDev-Growth-Microsoft Sales App
ProductDev-Growth-Salesforce Sales App
ProductDev-Growth-Salesforce Sales App
ProductDev-Growth-Salesforce Sales App
ProductDev-Growth-Microsoft Sales App
ProductDev-Growth-Microsoft Sales App
ProductDev-Growth-Microsoft Sales App
ProductDev-Growth-Salesforce Sales App
ProductDev-Growth-Salesforce Connector
ProductDev-Growth-Salesforce Sales App
ProductDev-Portal-Analytics
ProductDev-Growth-Salesforce Sales App
ProductDev-Growth-Salesforce Sales App
ProductDev-Growth-Salesforce Connector
ProductDev-Growth-Salesforce Sales App
ProductDev-Growth-Salesforce Sales App
ProductDev-Management
ProductDev-Growth-Salesforce Sales App
ProductDev-Growth-Salesforce Connector
ProductDev-Growth-Salesforce Sales App
ProductDev-Portal-Analytics
ProductDev-Portal-Analytics
ProductDev-Growth-Salesforce Sales App
ProductDev-Portal-Analytics
ProductDev-Portal-Analytics
ProductDev-Portal-Analytics
ProductDev-Portal-Analytics
ProductDev-Portal-Analytics
ProductDev-Growth-Microsoft Sales App
ProductDev-Portal-Analytics
ProductDev-Growth-Microsoft Sales App
ProductDev-Compliance-Salesforce App
ProductDev-Compliance-Salesforce App
ProductDev-Compliance-Salesforce App
ProductDev-Compliance-Salesforce App
ProductDev-Technical Writing
ProductDev-Technical Writing
ProductDev-Technical Writing
Business Development-Sales Operations
Business Development-Sales Operations
Business Development-Marketing
Business Development-Marketing
Administrative-Management
Administrative-HR
Administrative-Management
Administrative-Management
Administrative-Back Office
Administrative-Ops
Administrative-Ops
Administrative-Ops