取值 有重複 非第一次出現值 (9349)

一般 G3 {=OFFSET(D$1,MATCH(,0/(B$2:B$9=F3)/($D$2:$D$9<>""),),)

用VLOOKUP  H3 {=VLOOKUP(1,IF({1,0},(B$2:B$9=F3)*(D$2:D$9<>""),D$2:D$9),2,)