We help IT Professionals succeed at work.
Get Started

Need Help on a formula setting cell value

47 Views
Last Modified: 2020-01-26
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:
This problem has been solved!
Unlock 1 Answer and 1 Comment.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant

An Experts Exchange subscription includes unlimited access to online courses.

Get Started
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE