lundi 22 mai 2017

Excel Match function with IF and OR Statement

Excel Match Function 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