I basicaly have 2 worksheets and I would like to see if a match is found, if
the name is found in Sheet2
display Found otherwise Display Not Found.
For the most part it seems to work but for some reasons some should be found
but are not....
See below example

Sheet1.Name Results Sheet2.name

ABC'S Found AAA CS
A & B Shop Not Found ABC's CS
Curt Sporting Goods NOt Found ANDY's Place CS
CHUCK'S GUN AND PAWN Found BBB Shop CS
Duke's Not Found CCC's Goods
Dave's Shop Found CHAD's Shop
Don's Not Found Cuck's Gun and Pawn CS

Curt Sporting Goods CS
Dave's Shop CS
Don's


As you can see Don's is an Exact match (as far as I can tell) and it is not
found, Curt Sporting goods is real close and it displays not found. (CS
exists on Sheet2)

The formula that I am using in the results column is as follows:
=IF(SUM(IF(ISNUMBER(MATCH("*"&$B$2:$B$206&"*",Shee t2!$J$2:Sheet2!$J$553,0)),1,0))0,"Found","Not Found")


Any suggestions will be greatly appreciated

Thanks
TSharp