If you’ve ever tried to use Excel’s IF function with a wildcard, you’ll know that it doesn’t work. What do I mean by a wildcard? The most commonly-used wildcard is the asterisk (*) which represents “zero or more characters”. In the screenshot below, G2 contains the following formula:
=IF(F2=”Order*“,”Y”,”N”)
In other words, if F2 starts with the word Order and contains zero or more characters after the word Order, G2 will be Y otherwise G2 will be N
As you can see it hasn’t quite turned out that way and that’s because the IF function in Excel doesn’t support the use of wildcards. In this short video I show you a simple workaround