Forum Discussion
Solved
How to not show N/A in the cell.
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.
- rossshah You can use IFERROR in stead. Try =IFERROR(<your formula>,"")
2 Replies
- rossshah You can use IFERROR in stead. Try =IFERROR(<your formula>,"")
- '=IFERROR(IF(N2=VLOOKUP(M2,Q$1:R$5,2,FALSE),"good","does not match"),"")
Thanks you. It worked.
