æ¯å¦ï¼ç¬¬ä¸ä¸ªè¡¨ä¸ºsheet1,第äºä¸ªè¡¨ä¸ºsheet2,å§åå¨Aåï¼æ°åå¨Bå,两个表å§åä¸ä¸å¯¹åºï¼ä½é¡ºåºä¸åï¼å¯æ两个表对åºå§åçæ±åæ¾å°sheet1çCå
sheet1çC2è¾å ¥
=b2+vlookup(a2,sheet2!a:b,2,)
å ¬å¼ä¸æï¼è§ä¸å¾