Link to home
Start Free TrialLog in
Avatar of Matt Pinkston
Matt Pinkston

asked on

Need Help on a formula setting cell value

Need help with a excel column formula..

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
ASKER CERTIFIED SOLUTION
Avatar of Matt Pinkston
Matt Pinkston

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial