逐次找出經理人 (14080)

D3:I11(A欄開始可用)=IF($D$2=D$2,A3,IFERROR(VLOOKUP(INDIRECT("RC[-1]",),$A:$B,2,)&"",""))

另解=IF($D$2=D$2,A3,IFERROR(VLOOKUP(C3,$A:$B,2,)&"",""))