莽聸麓忙聨楼茅聙職猫驴聡EXCEL氓聡陆忙聲掳氓掳卤猫聝陆氓庐聻莽聨掳
氓聛聡猫庐戮盲陆聽莽職聞忙聲掳忙聧庐忙聵炉忙聰戮氓聹篓 A1氓聢掳J11
K氓聢聴忙聰戮莽職聞M莽禄聞莽職聞氓聬聧莽搂掳茂录聦L氓聢聴氓掳聠忙聰戮忙聣聙氓聹篓莽禄聞氓聢芦
猫驴聶忙聽路氓聹篓L1茂录聦猫戮聯氓聟楼氓聟卢氓录聫茂录職
=INDEX(A$1:J$11,1,SMALL(IF(A$1:J$11=K1,COLUMN(A$1:J$11)),1))
猫戮聯氓聟楼氓庐聦忙聢聬茂录聦忙聦聣 CTRL+SHIFT +ENTER 莽禄聯忙聺聼猫戮聯氓聟楼茫聙聜
莽聞露氓聬聨忙聤聤氓聟卢氓录聫忙聥聳盲赂聥忙聺楼氓聧鲁氓聫炉茫聙聜
