Search for string but with minus substring <p>I want to search for strings from a list but I do not want that value returned if the string contains the substring "banner". How would I do this?</p> <p>Thus far this is my formula for finding the string </p> <pre><code>=INDIRECT("A"&amp;(MATCH("*"&amp;RIGHT(D11,10)&amp;"*",$A:$A,0))) </code></pre> <p>I want to alter it so that it excludes strings including the substring "banner"</p>