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

[µo°Ý] ·s¤â½Ð±Ð

[µo°Ý] ·s¤â½Ð±Ð

§Ú·Q¥Îexcel¨î§@¤@­Óªí®æ­pºâ¸ò²Î­p¨C¦¸¶R½æ³f«~ªº¸ê®Æ,¦ý¦]¬°¤@­Ó¿z¿ï¤½¦¡¥d¦í¤F
¥H¤U¬°¨Ò¤l
§Ú©ó"°â³fªO"­¶a1Ä楴³f«~¸¹½X,a2¦Û°Ê©ó"¦s³fªO"¿z¿ï¬ÛÀ³³f¸¹³f®ÆÅã¥Ü©ó"°â³fªO"?
¬¡±o¦Û¦b!

¬Ý°_¨ÓµLÃö¿z¿ïªº°ÝÃD
§AÀ³¸Ó­nªº¬Ovlookup¨ç¼Æ
=vlookup(a1,¦s³fªO!¬Û¹ïÀ³°Ï°ì¡A²Ä´XÄæ¡Afalse)

TOP

¥i¥H¤F^^  ÁÂÁÂ!!§Ú³Q³o­Ó°ÝÃD¥d¦í¦n±`®É¶¡¤F!!  ÁÂÁÂ^^
¬¡±o¦Û¦b!

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¤Hªº§Ö¼Ö¡D¤£¬O¦]¬°¥L¾Ö¦³±o¦h¡A¦Ó¬O¦]¬°¥L­p¸û±o¤Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD