Excel – Compare two cells only if there is text in one. Otherwise display missing.


=IF(NOT(ISBLANK(G2)),(IF(A2=G2,””,”FALSE”)),”Missing”)