troubleshooting Question

Need Help on a formula setting cell value

Avatar of Matt Pinkston
Matt Pinkston asked on
Microsoft OfficeMicrosoft Excel
1 Comment1 Solution52 ViewsLast Modified:
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
Matt PinkstonSVP Product Strategy

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros