有任一指定值 取行列 (9750)

I2:M9{=INDEX(A:A,SMALL(IF(MMULT(COUNTIF($G:$G,$A$2:$E$9),ROW(1:5)^0),ROW($2:$8),99),ROW(A1)))&""

O2:S9{=INDEX(2:2,SMALL(IF(MMULT(COLUMN(A:H)^0,COUNTIF($G:$G,$A$2:$E$9)),COLUMN($A:$E),99),COLUMN(A1)))&""