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 un...
- rossshah You can use IFERROR in stead. Try =IFERROR(<your formula>,"")
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.
Thanks you. It worked.