如题所述
åä¸ªæ ·è¡¨ï¼è¯¦è§æªå¾ï¼ççæ¯ä¸æ¯ä½ æ³è¦çç»æ
æ°æ®æºå¨Sheet1
sheet2çA2è¾å ¥æ个æ°æ®ï¼æ¥è¯¢ç»ææ¾å°B2
b2è¾å ¥
=INDIRECT("sheet1!r2c"&MAX((Sheet1!A2:C11=A2)*COLUMN(A:C)),0)
å æä½ CTRL+SHIFT,æåæå车é®