IF a cell contains a word

Premium

In B2, show "Pro" if the product name in A2 contains "pro" anywhere, and "Standard" if it does not. IF has no wildcards, so test with ISNUMBER(SEARCH("pro",A2)).

B2
ABCDEF
1Product Line
2Laptop PRO 14
3Wireless mouse
4Monitor Pro 27
5Keyboard
6
7
8

Premium lesson

Unlock IF and every other lesson

This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.

Next with premium:COUNTIFSUMIF

Your first month for $9.50 $19

50% off your first month when you join today.

Get your first month for $9.50

Then $19/month. Cancel any time, and get a full refund within 14 days if it isn't for you.

Already premium? Sign in
Need help?