親,附件已上傳供參考。
C4的公式如下並下拉:
=IF(INDIRECT(B$2&"!C"&MATCH(B$3,INDIRECT(B$2&"!A:A"),)+ROW(A1)-1)=B4,INDIRECT(B$2&"!D"&MATCH(B$3,INDIRECT(B$2&"!A:A"),)+ROW(A1)-1),"")