Óû§Ãû£ºnhesyls
ËÑË÷'vlookup'²åÎÊ´ðÈ빫ʽ¼´¿É¡£
VLOOKUPº¯ÊýÊÇExcelÖеÄÒ»¸ö×ÝÏò²éÕÒº¯Êý£¬ËüÓëLOOKUPº¯ÊýºÍh**LOOKUPº¯ÊýÊôÓÚÒ»ÀຯÊý£¬ÔÚ¹¤×÷Öж¼Óй㷺ӦÓã¬ÀýÈç¿ÉÒÔÓÃÀ´ºË¶Ô**£¬¶à¸ö±í¸ñÖ®¼ä¿ìËÙµ¼Èë**µÈº¯Êý¹¦ÄÜ¡£¹¦ÄÜÊǰ´ÁвéÕÒ£¬×îÖÕ·µ»Ø¸ÃÁÐËùÐè²éѯÐòÁÐËù¶ÔÓ¦µÄÖµ£»ÓëÖ®¶ÔÓ¦µÄh**LOOKUPÊǰ´ÐвéÕҵġ£
Table_arrayÊÇËÑѰµÄ·¶Î§£¬col_index_**mÊÇ·¶Î§ÄÚµÄÀ¸Êý¡£Col_index_**m¡¡²»ÅɽÓÄÜСÓÚ1£¬ÆäʵµÈÓÚ1ҲûÓÐʲôʵ¼ÊÓõġ£Èç¹û³öÏÖÒ»¸öÕâÑùµÄ´íÎóµÄÖµ#REF!£¬Ôò¿ÉÄÜÊÇcol_index_**mµÄÖ**¬¹ý·¶Î§µÄ×Ü×Ö¶ÎÊý¡£
ѡȡTable_arrayÊ»¶¨×¢ÒâÑ¡ÔñÇøÓòµÄÊ×ÁбØÐëÓëlookup_valueËùѡȡ³¡×àÀ×ÕÒί³§ÏîÁùÉúÒªÖεÄÁеĸñʽºÍ×Ö¶ÎÒ»Ö¡£±ÈÈçlookup_valueѡȡÁË¡°ÐÕÃû¡±Öеġ°ÕÅÈý¡±£¬ÄÇôTable_arrayѡȡʱµÚÒ»ÁбØÐëΪ¡°ÐÕÃû¡±ÁУ¬ÇÒ¸ñʽÓëlookup_valueÒ»Ö£¬·ñÔò±ã»á³öÏÖ#N/AµÄÎÊÌâ¡£