excel公式,逻辑公式,如果A列等于B列,C列等于D列则返回 是;

2024-10-31 19:15:25
推荐回答(2个)
回答1:

=if(and(a1=b1,c1=d1),"是","否")

=if((A1=B1)*(C1=d1),"是","否")

回答2:

=IFERROR(INDEX(D:D,MATCH(A1,B:B,)),"")