请问在excel中该如何用公式实现表中自动填写?

2025-03-22 09:49:17
推荐回答(2个)
回答1:

B2公式下拉:

=IFERROR(INDEX(Sheet1!A:A,MATCH(A2,Sheet1!D:D,)),"")

C2公式下拉:

=IFERROR(IF(INDEX(Sheet1!E:E,MATCH(A2,Sheet1!D:D,))="剧毒","是",""),"")

回答2:

=IFERROR(VLOOKUP(A1,Sheet1!D:D,1,0),"")