最近日期 人員所屬部門 (14133)

G2=LOOKUP(1,0/(MONTH(A$2:A$16)=F2)/(C$2:C$16=E2),B$2:B$16)

H2{=LOOKUP(1,0/(MAX((MONTH(A$2:A$16)=F2)*(C$2:C$16=E2)*A$2:A$16)=A$2:A$16)/(C$2:C$16=E2),B$2:B$16)