æ¥è¯¢è¡¨ä¸è¬é½æ¯éè¿å§åæ¥æ¾æ绩çï¼æ以å¯ä»¥ç¨ç«ç´æ¥æ¾vlookupå½æ°ï¼è¯æ³æ¯
=VLOOKUP(æ¥æ¾å¯¹è±¡ï¼åºåï¼è¦è¿åçè¡æ°ï¼æ¯å¦è¦ç²¾ç¡®æ¥æ¾ï¼ä¸è¬ä¸º0ï¼
å
ååºæ绩åï¼å¦ä¸å¾çæèèè¯æ绩ï¼ä¸ºä¾¿äºè§çå°±å°ä¸ç¹äººæ°
åæ¥è¯¢åºåï¼å¨ç©ºç½çåå æ ¼æä¸ï¼å¦çå§åï¼ï¼æè¾¹åå æ ¼çç½å ä¸ä¸ªä¸å线ï¼J3)
åä¸è¯æï¼ä¸é¢è¾å ¥=VLOOKUP(J3,B5:E9,2,1),J3å°±æ¯è¦æ¥è¯¢çå¦çå§åï¼B5:E9æ¯æ´ä¸ªæ°æ®åºåï¼2å°±æ¯æ°æ®åºåç第äºè¡ä¹å°±æ¯å¯¹åºçè¯ææ绩ï¼å¦ææ¯3表示çå°±æ¯æ°å¦æ绩ï¼1表示精确æ¥æ¾å¯ä»¥ä¸åãåçåä¸æ°å¦åè±è¯ã
æ以å¨J3è¾å
¥å¦çå§åå³å¯æ¥è¯¢è¯¥å¦ççæ绩