Óû§Ãû£ºlizhaochen1994
ͨ¹ýËÑË÷'×ó¾É·¢¾à¶Ó˾²ÉÁ÷¼«È«vlookup'²¢²åÈ빫ʽÀ´ÎÊ´ðʵÏÖ¡£
VLOOK¶þUPº¯Êý×÷ΪExcelÖеÄÒ»¸öºËÐÄ×ÝÏò²éÕÒ¹¤¾¬ËüÓëLOOKUPºÍh**LOOKUPº¯ÊýͬÊôÒ»À࣬ÔÚÈÕ³£¹¤×÷ÖеÄÓ¦Óü«¾°×ùÐÞÏ޽龡ºú¸ïÀ´Ï¢Îª¹ã·º¡£ÎÞÂÛÊÇÓÃÓÚ**ºË¶Ô£¬»¹ÊÇÔÚ¶à¸ö±í¸ñ¼ä¿ìËÙµ¼Èë**£¬ºñʲʹÇáÖ§ÄïVLOOKUP¶¼·¢»Ó×ÅÖØÒª×÷Óá£ÆäÖ÷Òª¹¦ÄÜÊÇÔÚÖ¸¶¨ÁÐÖнøÐвéÕÒ£¬²¢·µ»Ø¸ÃÁÐÖÐÓë²éѯÐòÁÐÏà¶ÔÓ¦µÄÖµ£»¶øh**LOOKUPÔòÖ÷Òª¸ºÔð°´ÐнøÐвéÕÒ¡£
ÔÚʹÓÃVLOOKUPʱ£¬Table_array¶¨ÒåÁËËÑË÷µÄ·¶Î§£¬¶øcol_i×¥ndex_**mÔòÖ¸¶¨ÁË·¶Î§ÄÚÒª²éÕÒµÄÁв»¶ÜÑõʧÊý¡£ÖµµÃ×¢ÒâµÄÊÇ£¬col_index_**m±ØÐë´óÓÚµÈÓÚ1£¬ÇÒÈç¹ûÆäÖ**¬¹ýÁËTable_array·¶Î§ÄÚµÄ×ÜÁÐÊý£¬½«»áµ¼ÖÂ#REF!´íÎóµÄ·¢Éú¡£
ÔÚÑ¡ÔñTable_arr²ÎÌáÑîÕ¾¸ÕÔöÄêÊÜÏßay·¶Î§Ê±£¬Îñ±ØÈ·±£ËùÑ¡ÇøÓòµÄÊ×ÁÐÓëlookup_valueËùÑ¡ÁеĸñʽºÍ×Ö¶ÎÍêȫһÖ¡£¾ÙÀýÀ´Ëµ£¬Èç¹ûlookup_valueÑ¡ÔñÁË¡°ÐÕÃû¡±ÁÐÖеġ°ÕÅÈý¡±£¬ÄÇôTable_arraÈ»¹æ·Ê²»·¨yµÄÑ¡Ôñ±ØÐëÒÔ¡°ÐÕÃû¡±ÁÐ×÷ΪµÚÒ»ÁУ¬ÇÒ¸ñʽÏàͬ£¬·ñÔò½«»áÓöµ½#N/AµÄûչÎüÁ¦ÄÏÉóÎÊÌâ¡£