Can you use an AND with the match?

=isna(and(match( : ,false),match( : ,false),match( : ,false),match( :
,false)))

"Steve C" wrote:

Hello,
I'm familiar with the =isna(match( : ,false)) formula to match data for 2
columns. I have two spreadsheets with deduction codes and employee numbers
that i'm trying to match on one spreadsheet. Is it possilbe to match the
Employee #s based of the deduction codes. There are 1000s of records and i'm
trying to avoid having to reconcile the missing ded codes manually.

A B C D
EE #1 Ded Code1 EE #2 Ded Code2
111 MED 111 MED
222 MED 333 DEN
111 DEN 222 RET
333 RET 333 RET