Excel Wildcard IF - NOT WORKING! | If Cell Contains Text Then...

👍👍If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺. https://www.paypal.com/donate/?hosted... Thank you! 👍👍 Download the featured file here: https://www.bluepecantraining.com/wp-... In this video I demonstrate how to perform a wildcard "contains" test in an IF statement. You cannot use the wildcard characters *, ! in a logical test. The workaround is to use SEARCH and ISNUMBER. The SEARCH function will return a number if the text is found and ISNUMBER will convert the number to a TRUE result. Therefore you have your test. If you need to test for two partial match conditions you can combine tests in the AND function. AND returns TRUE if all tests are met. ------------------------