lundi 25 octobre 2021

IF, OR, MATCH FUNCTION IN EXCEL

do you guys know the error from this formula?

=IFERROR(IF(OR(MATCH(D3,'Sheet1'!$O$7:$O$67,1),MATCH(D3,'Sheet2'!$O$7:$O$67,1),MATCH(D3,'Sheet3'!$O$7:$O$67,1)),"YES"),"NO")

I checked the formula but the result is always "NO", when I checked it manually the result should be "YES", is there anything that I missed?

Aucun commentaire:

Enregistrer un commentaire