mercredi 2 septembre 2020

How to put AND statement within a IF Vlookup & ISNA formula

I would like to put an AND statement within the below formula but I keep getting the error "You have entered too few arguments", is anyone able to help please?

=IF(ISNA(VLOOKUP(A2,$D$2:$D$4,1,FALSE)),"No","Yes")

Aucun commentaire:

Enregistrer un commentaire