=IF(ISNUMBER(SEARCH("Best",AG5)),"N","D")

Malvaro wrote:
For whatver reason the wildcard doesn't seem to be pulling alternative
spellings into the TRUE/FALSE criteria check. Column AG contains many
various companies, which then need to be sorted into two classes (N or
D).

My question is regarding the wildcard, which doesn't seem to be working
properly. If column AG contains: BestBuy, Best Buy, and Best Buy Co...
the formula is counting each of them as a FALSE statement because the
formula is only pulling the exact phrase of "Best" instead of "Best
(*everything after it)".

This is my current Excel 2003 formula:

=IF(OR(AG5="Good*",AG5="Best*",AG5="Circuit*"),"N" ,"D")

What do I need to change so that the formula will pull in the wildcard
results of Best_Buy_, Best _Buy_, and Best__Buy_Co_ and specify them as
a TRUE statement and list "N" as the final result? :)