Forum Discussion
SYNTAX ISSUE
Syntax help requested I have this formula =IF(AND(ISNA(MATCH(B5,Sheet3!A5:A3349,0)),ISNA(MATCH("*"&A5&"*",Sheet3!D5:D3349,0))),"NO","YES") which I made by combining =IF(ISNA(MATCH(B2,Sheet3!A2:A3346,0...
Hi,
In fact, there is no error!
This is how the logic in https://www.ablebits.com/office-addins-blog/2014/12/17/excel-and-or-xor-not-functions/ 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