Óû§Ãû£º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º¯Êý¡£²»È»ÈÝÒ׳ö´í¡£Êý×éÖеÄÊýÖµ±ØÐë°´ÉýÐòÅÅÐò¡£