如题所述
éè¦æä¸ªå¯¹ç §è¡¨æè å«ååºç¡è¡¨ï¼æ¯å¦æ¯sheet1ï¼Aåå§åï¼Båç¼å·ï¼Cåå°åçµè¯
sheet2为æ¥è¯¢è¡¨
Aåå§åï¼B2è¾å ¥
=VLOOKUP($A2,Sheet1!$A:$C,COLUMN(B1),)
å ¬å¼å³æä¸æ