二列原始数 找對應序号 (10119)

G2=IFERROR(VLOOKUP(F2,A:C,3,),VLOOKUP(F2,B:D,3,))

多列原始数=INDIRECT(TEXT(SUMPRODUCT((A$2:B$9=F2)*(ROW($2:$9)/1%+COLUMN(C:D))),"!R0C00"),)

多列原始数=OFFSET(B$1,SUMPRODUCT((A$2:B$9=F2)*ROW($1:$8)),SUMPRODUCT((A$2:B$9=F2)*COLUMN(A:B)))