How to not show N/A in the cell.

[rossshah]

Hello,  Above formula works.  However if there is no match in table 2 ("a" is not in table 2, Cell O3 returns as #N/A.    Need to use ISNA function within the the formula above but have been unsuccessful.  How do I not show #N/A?   Appreciate the help.    Thanks.   

[#2 · Accepted solution]

@rossshah You can use IFERROR in stead. Try =IFERROR(<your formula>,"")

[#3]

'=IFERROR(IF(N2=VLOOKUP(M2,Q$1:R$5,2,FALSE),"good","does not match"),"")

Thanks you. It worked.