ExcelÖÐlookupº¯ÊýµÄ¾ßÌåÓ÷¨ÊÇÔõÑùµÄ£¿

ʱ¼ä£º2019.11.17 ·¢²¼ÈË£ºgoodshell

ExcelÖÐlookupº¯ÊýµÄ¾ßÌåÓ÷¨ÊÇÔõÑùµÄ£¿

Òѽâ¾öÎÊÌâ

¹È¸ègoodshellÓû§ÔÚ2019.11.17Ìá½»Á˹ØÓÚ¡°Ì«¼àExcelÖÐlookupº¯ÊýµÄ¾ßÌåÓ÷¨ÊÇÔõÑùµÄ£¿¡±µÄÌáÎÊ£¬»¶Ó­´ó¼ÒÓ¿Ô¾·¢±í×Ô¼ºµÄ¹Ûµã¡£Ä¿Ç°¹²ÓÐ1¸ö»Ø´ð£¬×îºó¸üÐÂÓÚ2024-12-05T05:55:48¡£Ï£Íû´ó¼ÒÄܹ»°ïÖúËý¡£

ÏêϸÎÊÌâÃèÊö¼°ÒÉÎÊ£ºÆÚ´ýÄúµÄ´ð°¸£¬Ð»ÁË,Ï´ÎÓÐʶù±ðÍüÁËÕÒÎÒ £¡

Ï£ÍûÒÔϵĻشð£¬Äܹ»°ïÖúÄã¡£

µÚ1¸ö»Ø´ð

Óû§Ãû£ºtrfsf  

Excel»¥ÖÐLOOKUP²éѯº¯ÊýµÄÖ÷Òª¹¦ÄÜÊÇÔÚij¸ö²éÕÒÇøÓòÄÚ£¬ÕÒµ½Ä³¸öÐèÒªµÄËÑË÷Öµ£¬²¢°Ñ¸ÃËÑË÷Öµ·Åµ½Ìض¨µÄµ¥Ôª¸ñÄÚ¾Ö´òÄÃÍ¼ÐøÍõÖ³²Åί¡£LOOKUP²éѯº¯ÊýÁ£Àà±ØÕ¹ÊÜÌØµÄʹÓù«Ê½ÊÇ¡°=LOOKUP£¨ËÑË÷µ¥Ôª¸ñ£¬ËÑË÷ÇøÓò£¬·µ»ØÊýÖµÇøÓò£©¡±¡£

1¡¢´ò¿ªExcelÈí¼þ£¬ÊäÈëÏà¹Ø¹¤×÷±í¡£

2¡¢¸ù¾Ý¹¤×÷±í×ó±ßµÄµ¥Ôª¸ñÄÚÈÝ£¬¼´µ¥Ôª¸ñA1µ½µ¥Ôª¸ñC5µÄÇøÓò£»²éÕÒ³öE2µ¥Ôª¸ñµÄ²¿ÃÅÖµF2¡£

3¡¢½«Êó±ê**µ½µ¥Ôª¸ñF2£¬Ôڸõ¥Ôª¸ñÖÐÊäÈë¡°=LOOKUP(E2,A2:A5,B2:B5)¡±¡£

4¡¢º¯Êý¹«Ê½ÊäÈëÍê³ÉÒԺ󣬵ã»÷¼üÅÌÉϵġ°Í³ÇìÊÆEnter¡±¼ü£¬³öÏÖ²éѯ½á¹û¡£

5¡¢¶Ô±È¹¤×÷±í×ó±ßµÄ¸öÈ˲¿ÃÅÐÅÏ¢£¬¿ÉÒÔÄîµ÷À´ÂèÉí¸ú¾Ùδ¿´µ½²éÕҵIJ¿ÃÅÐÅÏ¢ÊÇÒ»ÑùµÄ£¬Õâ¾ÍÊÇLOOKUP²éÕÒº¯ÊýµÄ×÷Óá£

×¢±ÊÏß³ÌÒâÊÂÏ

1¡¢ÔÚʹÓÃLOOKUPº¯ÊýµÄʱºò£¬×¢ÒâLOOKUPº¯ÊýÐèÒª´óд¡£

2¡¢ÔÚʹÓÃLOOKUPº¯ÊýµÄʱºò£¬¡°()¡±ºÍ¡°,¡±ÐèÒªÔÚÓ¢ÎÄ״̬ÏÂÊäÈë¡£È磺¡°=LOOKUP(E2,A2:A5,B2:B5)ÒÒ˳Áª¹ÜºòУδϸ¼ù¡±¡£

3¡¢Òª²éÕÒµÄֵλÓÚÊý×éµÄµÚÒ»ÁлòµÚÒ»ÐУ¬ÇÒ·µ»ØÖµÔÚ¸ÃÊý×éµÄµÚÒ»ÁлòµÚÒ»ÐУ¬¿ÉÒÔʹÓÃÊý×éÐͲéÕÒlookupº¯Êý¡£²»È»ÈÝÒ׳ö´í¡£Êý×éÖеÄÊýÖµ±ØÐë°´ÉýÐòÅÅÐò¡£