Hi, I have been working on this formula for hours and cannot get it right. Please help! Column C has either TRUE or FALSE. Columns L and M have either a number or #N/A (depending on whether there was a number on the source data - this data has come from a vlookup). What I want, in column N is to say if column C says TRUE there is a number in either column L or M. So of C says TRUE and either/and L and M holds a number, N to say MATCH. This is what I have tried: =IF(OR(AND(C16="TRUE",ISNUMBER(L16)),AND(C16="TRUE",ISNUMBER(M16))),"MATCH","NOTMATCH") but all my results are showing as NOTMATCH. What am I doing wrong? Thanks so much!