Aug 16 2019 03:24 PM
Aug 16 2019 09:40 PM
Hi,
In fact, there is no error!
This is how the logic in AND function works.
The formula will return "NO" only if both matches return #N/A.
If you want the formula to return "NO" if at least one Match return #N/A, then you can use OR function instead, like the following:
=IF(OR(ISNA(MATCH(B5,Sheet3!A5:A3349,0)),ISNA(MATCH("*"&A5&"*",Sheet3!D5:D3349,0))),"NO","YES")
Hope that helps