Return a value when 2 conditions are met

[viewotst]

Hello everybody,

I hope you are well.

I have a list with some job titles. If the job title contains the word Marketing or Production, I want "Salary increase" as the result and "No Salary increase" if the condition is not met.

The column H is showing N/A as it does not let me add "no salary increase".

Can you please help.

Thanks
Sanchez

[sandy666]

If the job title contains the word Marketing or Production, I want "Salary increase" as the result

with Power Query

Title	Result
Production manager	Salary increase
Marketing director	Salary increase
Sales Operative	No Salary increase
Operations manager	No Salary increase
Human Resources	No Salary increase
IT manager	No Salary increase
Supply Chain and Production	Salary increase
Customer Service support	No Salary increase
Marketing advisor	Salary increase

Please Login or Register  to view this content.

[HansDouwe]

Please try in H5 and copy down:

Please Login or Register  to view this content.

[Phuocam]

Or try this

Please Login or Register  to view this content.