Hi there , I have this formula
=IFERROR(IF(MATCH(A2,G:G,0)*OR(MATCH(B2,G:G,0)),"Present",),"Absent")
What I want is to return Present if one of the email from Column A and B present in Column G.
The Formula Work with *And but its not working with *OR.
Aucun commentaire:
Enregistrer un commentaire