=IF(ISNUMBER(MATCH(G1,Events!A:A,0))=TRUE,"E","NE")
the above formula works perfectly fine, but I need to show
the values "E" or "NE" only if cell F2 has text
I have tried =ISTEXT(F2),(ISNUMBER(MATCH(G1,Events!A:A,0))=TRUE,"E","NE"), "")
but doesn't work, help help fix the formula.
Thank you,
Bookmarks