How to not show N/A in the cell.

%3CLINGO-SUB%20id%3D%22lingo-sub-2697404%22%20slang%3D%22en-US%22%3EHow%20to%20not%20show%20N%2FA%20in%20the%20cell.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2697404%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22rossshah_0-1630288733436.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F306594i6E4F3C0B893C9773%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22rossshah_0-1630288733436.png%22%20alt%3D%22rossshah_0-1630288733436.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EHello%2C%26nbsp%3B%20Above%20formula%20works.%26nbsp%3B%20However%20if%20there%20is%20no%20match%20in%20table%202%20(%22a%22%20is%20not%20in%20table%202%2C%20Cell%20O3%20returns%20as%20%23N%2FA.%26nbsp%3B%20%26nbsp%3B%20Need%20to%20use%20ISNA%20function%20within%20the%20the%20formula%20above%20but%20have%20been%20unsuccessful.%26nbsp%3B%20How%20do%20I%20not%20show%20%23N%2FA%3F%26nbsp%3B%20%26nbsp%3BAppreciate%20the%20help.%26nbsp%3B%20%26nbsp%3B%20Thanks.%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2697404%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2697448%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20not%20show%20N%2FA%20in%20the%20cell.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2697448%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1140763%22%20target%3D%22_blank%22%3E%40rossshah%3C%2FA%3E%20You%20can%20use%20IFERROR%20in%20stead.%20Try%20%3DIFERROR(%3CYOUR%20formula%3D%22%22%3E%2C%22%22)%3C%2FYOUR%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2697464%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20not%20show%20N%2FA%20in%20the%20cell.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2697464%22%20slang%3D%22en-US%22%3E'%3DIFERROR(IF(N2%3DVLOOKUP(M2%2CQ%241%3AR%245%2C2%2CFALSE)%2C%22good%22%2C%22does%20not%20match%22)%2C%22%22)%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%20you.%20It%20worked.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

rossshah_0-1630288733436.png

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 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.