ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ½Ð±Ð¡Gvlookupªº°ÝÃD

[µo°Ý] ½Ð±Ð¡Gvlookupªº°ÝÃD

½Ð±Ð¦U¦ì«e½ú¡ã

§Ú·|¦b¢Ð¢²¡ã¢Ô¢¶¶ñ¤J¤H­ûªº¥N¸¹¡AµM«á¦b¢Ð¢·¡ã¢Ô¢°¢±³]©w¦p¤Uªº¹ïÀ³¨ç¼Æ¡A¥H«K§ä¥X¸ê®Æ
=IF(VLOOKUP(B3,°ò¥»¸ê®Æ,2)="","",VLOOKUP(B3,°ò¥»¸ê®Æ,2))

¥i¬O¬°¦ó·í¢Ð¢²¡ã¢Ô¢¶¤§¶¡¦³ªÅ¥Õ¨S¶ñ¤J¼Æ¦r®É¡A¬Û¹ïÀ³ªº¢Ð¢·¡ã¢Ô¢°¢±°Ï°ì¤´·|¥X²{¡­¢Ü¡þ¢Ï¦Ó«DªÅ¥Õ©O¡H
¬O§_¤W­z¨ç¼Æ³]©w¦³»~¡H½Ð¦U¦ì½ç±Ð¡A·P®¦¡I

¦^´_ 1# onegirl0204

=IF(ISERROR(VLOOKUP(B3,°ò¥»¸ê®Æ,2,0)),"",VLOOKUP(B3,°ò¥»¸ê®Æ,2,0))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh


«D±`·PÁ¡ãÁ«e½úªº½ç±Ð¡A¸Ñ¨M¤F§xÂZ§Ú«Ü¤[ªº°ÝÃD¡I

¦A½Ð±Ð¤@¤U¡A§ÚÁÙ¦³§Oªº¦a¤èªº¨ç¼Æ¤½¦¡­Y­n­×§ï¦¨±z«Øijªº¨ç¼Æ¼gªk¡A®£©È·|³Ò®v°Ê²³­C¡I¦³¨S¦³¤°»ò¿ìªk¥i¥H§Ö³t­×§ïªº©O¡H

´N¹³½s¿è¡ã¨ú¥N¡ã³oºØ¤è¦¡¡A¤@¦¸©Ê­×§ï¨ç¼Æ¤½¦¡¡A­n¤£µM§Ú±o¤@­Ó¤@­Ó¥s¥X¨Ó­×§ï§r¡I:'(

¤£¦n·N«ä¡ã¦A³Â·Ð±zÅo¡I·P®¦¡I

TOP

¦^´_ 3# onegirl0204
³q±`¤½¦¡³]©w·|¦³¦V¤U©Î¦V¥k½Æ»sªº»Ý¨D
§ä¥X¦P¤@ºØ¤½¦¡ªº¥ª¤W¨¤¨Ó­×§ï¡AµM«á¦V¥k¦V¤U©ì¦²½Æ»s
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# Hsieh


Á«e½ú±z¦n¡ã

±z»¡ªº¬O«ü¾ãÄæ©Î¾ã¦C¨ç¼Æ¤½¦¡©Ê½è¬Û¦Pªº¡A¦ý§Ú¦³¨Ç¤u§@ªí¸Ìªº¨ç¼Æ¤½¦¡«o¬O¨S¯S©w¦ì¸m¡A¨Ì§Úªºªí®æ»Ý¨D¦Ó²§¤À´²¦b§e²{¤£³W«h±Æ¦CªºÀx¦s®æ¸Ì¡A¾É­P¥²¶·¤@¤@­×§ï¡A¤~·|¦³­×§ï¤Wªº§xÂZ§r¡I

¥t¥~¡A§ÚÁÙ¦³¤@ºÃ¼{¡Gvlookup¨ç¼Æ¸Ì¸ê®ÆÄ檺§Ç¸¹¬O­Ó³Â·ÐÂI¡A¨Ò¦p¡G¹q¸Ü¸¹½X°²³]­ì¥»¦b¸ê®Æ®w¿ï¨ú½d³ò¸Ìªº²Ä¢³Äæ¡A¦pªG¦b¥¦¤§«e´¡¤J¤@­«­nÄæ¦ì¡A¹q¸Ü¸¹½X¶Õ¥²Åܦ¨²Ä¢´Äæ¡A¨º»ò­ì¥»³]¦nªºvlookup¨ç¼Æ©Ò¹ïÀ³¥Xªº¸ê®Æ´N·|¿ù»~¤F¡I

·íµM±z¤@©w·|»¡¡G¦b³]©w¤½¦¡¤§«e´N­n¦Ò¶q¦nÄæ¦ìªº¶¶§Ç¡A¥i¬O¤HÃø§K¦³²¨©¿¹À¡I¬Æ¦Ü¦³®É¬O¦]¤u§@»Ý¨D¡A¥²¶·´¡¤J­«­nªºÄæ¦ì®É¡A´N·|²£¥Í¤W­z°ÝÃD¤F¡I¤£ª¾¹ï©ó¦¹°ÝÃD¡A±z¦³¦ó¨}µ¦©O¡H·Ð½Ð¦A¦¸½ç±Ð¡A·P®¦¡I

TOP

¦^´_ 5# onegirl0204
VLOOKUP­n¦]À³Äæ¦ìÅÜ°Ê¡A¥i§Q¥ÎMATCH´M§ä¼ÐÃD°µ¬°Äæ¦ì¨Ì¾Ú
¦Ü©ó§A­n­×§ï¤½¦¡³¡¤À·íµM¥i¥H§Q¥Î´M§ä¨ú¥N¥\¯à¡A¥u¬O¥²¶·Åý¨C¦¸¨ú¥N«áªº¤½¦¡¥²¶·»yªk¥¿½T
©Ò¥H¡A¨ãÅé¤WÁÙ¬O­n¬Ý§Aªº­ì¤½¦¡»P­×§ï«á¤½¦¡¬O§_¦³³W«h¥i´`¡A§_«h´N¥²¶·¤@¤@®Õ¹ï­×§ï¤F
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 6# Hsieh


Á«e½ú±z¦n¡ã

±zªº·N«ä¬O»¡¡G°²³]§Ú­ì¥»¤w³]¦nªºvlookup¨ç¼Æ­Y¦]¬°´¡¤J¤@Äæ¡A¨Ï±o­ì¥»vlookup¨ç¼Æ¹ïÀ³Äæ¦ì¬°¢´ªºÅܦ¨¢µ¡A¹ïÀ³Äæ¦ì¬°¢·ªºÅܦ¨¢¸¡D¡D¡D¡D¥H¦¹Ãþ±À
³oºØ±¡§Î¦³¿ìªk¥Î´À¥N¥\¯à¤@¦¸©Ê¸Ñ¨M¡A¦Ó¤£¥²³v¤@­×§ï¤½¦¡Åo¡I­Y¯u¥i¦p¦¹¡A¯u¬O¤Ó§¹¬ü¤F¡I

Á٬߫e½ú½ç±Ð¡A·P®¦¡I

TOP

¦^´_ 7# onegirl0204

¦pªþ¥óªº·§©À¡A°Ñ¦Ò¬Ý¬Ý

    vlookup.rar (3.66 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 8# Hsieh


·PÁ±zªº½ç±Ð¡IÅý§Ú¦h¾Ç·|¤Fvlookup©Mmatch¦P®É¦X¨Ö¨Ï¥Îªº·s©Û¦¡¡A§Ú·|¦n¦n¬ã¨s§ï¶i­ì¦³ªº¤½¦¡¡A·P®¦¡I

TOP

        ÀR«ä¦Û¦b : ªY½à§O¤H´N¬O²øÄY¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD