Óû§Ãû£ºs0h6p9241h7
ͨ¹ýËÑË÷'vlookup'²åÈ빫ʽÀ´ÌåÑéÆä±ã½ÝÐÔ¡£
VLOOKUPº¯Êý×÷ΪExcelÖеÄÒ»¸öºËÐÄ×ÝÏò²éÕÒ¹¤¾¬ËüÓëLOO¾ßÇòËïÍ£Ì﹤ÀûÍû³Ç×ÊKUP¡¢h**LOOKUPº¯ÊýͬÊôÒ»À࣬ÔÚÈÕ³£¹¤×÷ÖеÄÓ¦Óù㷺¡£ÎÞÂÛÊÇÓÃÓÚ**ºË¶Ô£¬»¹ÊÇÔÚ¶à¸ö±í¸ñ¼äÎÊ´ð¿ìËÙµ¼Èë**£¬VLOOÇ×ÑÐÕ¾³ÂÅÉÎóÒ¶³§ÓÃÀ¼KUP¶¼·¢»Ó×ÅÖØÒª×÷Óá£ÆäÖ÷Òª¹¦¼ÃÄ³Â¶ÖØµÄζ·¢»õ̽ÄÜÊÇÔÚÖ¸¶¨ÁÐÖнøÐвéÕÒ£¬²¢·µ»Ø¸ÃÁÐÖÐÓë²éѯÐòÁÐÏà¶ÔÓ¦µÄÖµ¡£Ïà±È֮ϣ¬h**LOOKUPÔòÊÇÔÚÐÐÖнøÐвéÕÒ¡£
ÔÚʹÉú×ÓÓÃVLOOKUPʱ£¬Table_array¶¨ÒåÁËËÑË÷µÄ·¶Î§£¬¶øcol_index_**mÔòÖ¸¶¨ÁË·¶Î§ÄÚÒª²éÕÒµÄÁÐÊý¡£ÐèҪעÒâµÄÊÇ£¬col_index_**m²»ÄÜСÓÚ1£¬Êµ¼ÊÉÏ£¬ÉèÖÃΪ1µÄÇé¿ö²¢²»³£¼û¡£Èç¹ûÔÚʹÓüþÔÓº£·Ñ¹ý³ÌÖÐÓöµ½#REF!ÕâÑùºÁºÁÒ»ËáÊ·¸±Ö樳õµÄ´íÎóÖµ£¬ÄÇ¿ÉÄÜÊÇÒòΪcol_index_**mµÄÖ**¬³öÁËTable_array·¶Î§µÄ×ÜÁÐÊý¡£
ÁÙÔÚÑ¡ÔñTable_array·¶Î§Ê±£¬Îñ±ØÈ·±£ËùÑ¡ÇøÓòµÄÊ×ÁÐÓëlookup_valueËùЩ¶ÈÀ¨¾ßÁãÁ÷ɢʱ¾«ÔØÑ¡ÁеĸñʽºÍ×Ö¶ÎÍêȫһÖ¡£ÀýÈ磬Èç¹ûlookup_valueÑ¡ÔñÁË¡°ÐÕÃû¡±ÁÐÖеġ°ÕÅÈý¡±£¬ÄÇÃ´Ðø¶«Í³ÐÞTable_arrayµÄµÚÒ»²ÉȫͶ·áÁбØÐëÊÇ¡°ÐÕÃû¡±ÁУ¬²¢ÇÒ¸ñʽҲҪÓëlookup_value±£³ÖÒ»Ö¡£·ñÔò£¬½«»áµ¼ÖÂ#ν¼Ò´ðÕëδʲæÃÍâN/A´íÎóµÄ³öÏÖ¡£