We help IT Professionals succeed at work.

Need Help on a formula setting cell value

Matt Pinkston
Matt Pinkston asked
on
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
Comment
Watch Question

Enterprise Architect
Commented:
=IF(LEFT(I2,27)="ProductDev-Portal-Analytics","Analytics",IF(LEFT(I2,18)="ProductDev-Portal-","Portal",IF(LEFT(I2,22)="ProductDev-Compliance-","GRC",IF(RIGHT(I2, 9)="Connector","Analytics",IF(LEFT(I2, 18)="ProductDev-Growth-","Growth","")))))