如图O4=VLOOKUP($M4&$N4,IF({1,0},INDIRECT("A"&SMALL(IF(($A$4:$A$15=$M4)*($B$4:$B$15=$N4),ROW($4:$15)),COUNTIFS($M$4:$M4,$M4,$N$4:$N4,$N4))&":A15")&INDIRECT("B"&SMALL(IF(($A$4:$A$15=$M4)*($B$4:$B$15=$N4),ROW($4:$15)),COUNTIFS($M$4:$M4,$M4,$N$4:$N4,$N4))&":B15"),INDIRECT(CHAR(64+COLUMN(C1))&SMALL(IF(($A$4:$A$15=$M4)*($B$4:$B$15=$N4),ROW($4:$15)),COUNTIFS($M$4:$M4,$M4,$N$4:$N4,$N4))&":"&CHAR(64+COLUMN(C1))&"15")),2,)三键横拉下拉