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

[µo°Ý] vlookup °ÝÃD

[µo°Ý] vlookup °ÝÃD

¦U¦ì®v¥S, ¤p§Ì·s¤â, ¦³ÂIÃö©óvlookup¬J°ÝÃD·Q½Ð±Ð¤U,
¦pªG§Ú«Y¨­¤@®ævlookup , ¨Ò¦p =vlookup(a3,b1:b1000,2,0)
¤§«ácopy ¸¨¤U¤@®æ, ­Óformula ¤J­±d¼Æ­È·|¸òÀH§ïÅÜ, ¨Ò¦p  
=vlookup(a4,b2:b1001,2,0)
=vlookup(a5,b3:b1002,2,0)
...............
¦pªG§Ú·Qcopy¬J®É­Ô, «ü©w¬Y­Ó¯S©w½d³ò, ¥i¥HÂI°µ©O ??

¦^´_ 1# yowhome
=vlookup(a3,$b$1:$b$1000,2,0)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_  yowhome
=vlookup(a3,$b$1b$1000,2,0)
Hsieh µoªí©ó 2013-3-25 14:54


=VLOOKUP(A3,$A$1:$B$1000,2,0)

TOP

¦^´_ 3# JBY

¥u±Mª`¦bµ´¹ï°Ñ·Ó°ÝÃD¡A¥¼µo²{¼Ó¥D¤½¦¡ªºÄæ¦ì¼Æ¤£¨¬
¦hÁ«ü¥¿!!
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¤w¸Ñ¨M, ¦hÁ¦U¦ì¤j¤j.

TOP

        ÀR«ä¦Û¦b : °ß¨ä´L­«¦Û¤vªº¤H¡A¤~§ó«i©óÁY¤p¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD