B2公式下拉:
=IFERROR(INDEX(Sheet1!A:A,MATCH(A2,Sheet1!D:D,)),"")
C2公式下拉:
=IFERROR(IF(INDEX(Sheet1!E:E,MATCH(A2,Sheet1!D:D,))="剧毒","是",""),"")
=IFERROR(VLOOKUP(A1,Sheet1!D:D,1,0),"")