Excel's IF function doesn't support wildcards. In other words, you can't do something like =IF(G2="Order*","Yes","No"). In this video I show you a simple workaround to a common problem. ð Notes and Resources Download a copy of the files used in this video: https://app.box.com/s/tf72nmddkzn4uhj... â Want more FREE training? Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at https://theexceltrainer.co.uk ðââïļ Let's connect on social Twitter:   / theexceltrainer  Facebook:   / theexceltrainer  LinkedIn:   / thomasmik  #excel #wildcard #if