excelµÄlookupº¯ÊýÔõôÓÃ

ʱ¼ä£º2016.08.25 ·¢²¼ÈË£ºp0s3b3n1z975

excelµÄlookupº¯ÊýÔõôÓÃ

Òѽâ¾öÎÊÌâ

¹È¸èp0s3b3n1z975Óû§ÔÚ2016.08.25Ìá½»Á˹ØÓÚ¡°Éú»¯Î£»úexcelµÄlookupº¯ÊýÔõôÓá±µÄÌáÎÊ£¬»¶Ó­´ó¼ÒÓ¿Ô¾·¢±í×Ô¼ºµÄ¹Ûµã¡£Ä¿Ç°¹²ÓÐ1¸ö»Ø´ð£¬×îºó¸üÐÂÓÚ2024-12-05T06:03:41¡£Ï£Íû´ó¼ÒÄܹ»°ïÖúËý¡£

ÏêϸÎÊÌâÃèÊö¼°ÒÉÎÊ£ºÆÚ´ýÄúµÄ´ð°¸£¬Äã¾ÍÊǵ±´úµÄ»îÀ×·æ,Ì«¸ÐлÁË £¡

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

µÚ1¸ö»Ø´ð

Óû§Ãû£ºwangxiao654329  

º¯Êý**4¸ö²ÎÊý£¬¸ñʽÊÇ£º

=VLOOKUP(ÐèÒª²éÕÒµÄÖµÀ´×Ô,**ÕÒµÄÇøÓò,·µ»Ø**ÕÒÇøÓòµÄµÚ¼¸ÁÐÊý̨¾Ý,ÒÔ¾«È·»¹ÊÇÄ£ºý·½Ê½²éÕÒ)


È繫ʽ£º

=VLOOKUP(C1,A:B,2,0)


¸Ã¹«Ê½µÄÒâ˼¾ÍÊÇÒÔC1µÄÖµµ½AÁÐÖвéÕÒ£¨×¢Ò⣺**ÕÒÖµC1£¬±ØÐëλÓÚ²éÕÒÇøÓòµÄµÚÒ»ÁУ¬¼´AÁУ©£¬ÕÒµ½ºó·µ»Ø¶ÔÓ¦µÄBÁеÄÖµ£¬ÄǸöÊý×Ö2¾ÍÊÇ´ú±íA:BÕâ¸öÇøÓòµÄµÚ2ÁУ¬Ò²¾ÍÊÇBÁÐÁË¡£


¹«Ê½ÖÐ×îºóµÄ0´ú±í¾«È·²éÕÒµÄÒâ˼£¬¾ÍÊÇÒªÕÒµ½ÍêÈ«ÏàͬµÄ£¬²ÅËãÕÒµ½¡£Èç¹û°Ñ0¸ÄΪ1£¬Ôò´ú±íÄ£ºý²éÕÒ¡£Õâ¸ö0Æäʵ¿ÉÒÔÊ¡ÂÔ£¬Ê¡ÂÔʱĬÈϾÍÊÇ0£¬µ«0Ç°ÃæµÄ¶ººÅ²»ÄÜÊ¡ÂÔ¡£


¸üΪÏêϸµÄ½âÊͿɼòÊ÷˹ÒÔ°Ù¶È£º

excelvlookupº¯Êý

ÓÐÒ»´ó¶ÑÏà¹ØµÄÊÓÆµ½Ì³Ì£¬±ÈÓÃÎÄ×ÖµÄÃèÊö·½Ê½ÒªÈÝÒ×Àí½â³¡Òô¶ÔµÃ¶à¡£