同编号有日期显示 文字 (10270)

H2:I12=IF(OFFSET($A$1,MATCH($G2,$A:$A,)-1,COLUMN(A1)*2)<>"",CHOOSE(COLUMN(A1),"已镀膜","已出货"),"")

另解=IF(VLOOKUP($G2,$A:$E,COLUMN(A1)*2+1,)<>"",CHOOSE(COLUMN(A1),"已镀膜","已出货"),"")