Óû§Ãû£º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º¯Êý
ÓÐÒ»´ó¶ÑÏà¹ØµÄÊÓÆµ½Ì³Ì£¬±ÈÓÃÎÄ×ÖµÄÃèÊö·½Ê½ÒªÈÝÒ×Àí½â³¡Òô¶ÔµÃ¶à¡£