ããVLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])ã
ãã表述就æ¯VLOOKUP(æ¥æ¾å¼ï¼æ¥æ¾èå´ï¼æ¥æ¾åæ°ï¼ç²¾ç¡®å¹é
æè
è¿ä¼¼å¹é
)
ããvlookupå°±æ¯ç«ç´æ¥æ¾ï¼å³åæ¥æ¾ãéä¿ç讲ï¼æ ¹æ®æ¥æ¾å¼åæ°ï¼å¨æ¥æ¾èå´ç第ä¸åæç´¢æ¥æ¾å¼ï¼æ¾å°è¯¥å¼åï¼å
è¿åå¼ä¸ºï¼ä»¥ç¬¬ä¸å为åï¼å¾åæ¨æ°æ¥æ¾åæ°å¼çè¿ä¸åæ对åºçå¼ã
ããè¿å
¬å¼å¨ææè¡¨æ ¼é½éç¨çï¼æ³¨æä¸æ导å
¥çæ°æ®åå¨ä¸¤ä¸ªè¡¨çå±æ§æ ¼å¼è¦ç¸åï¼ä¸ç¶å¯¼ä¸è¿æ¥ï¼ç¹å³é®éæ©è®¾ç½®åå
æ ¼æ ¼å¼å³å¯ã