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

[µo°Ý] ½Ð°Ý¤@¤U¦p¦ó§â¤@­Ó½d³òÂন¤@­Ó©ú²Óªí(¤u§@ªí)?

[µo°Ý] ½Ð°Ý¤@¤U¦p¦ó§â¤@­Ó½d³òÂন¤@­Ó©ú²Óªí(¤u§@ªí)?

Á|¨Ò
A1:B100 ©w¸q¬° ©ú²Óªí¤@
¦Ó§Ú¦b¥´¤½¦¡®É´N¥i¥H¥´¦¨
=vlookup(A1,©ú²Óªí¤@,5)

¦Ó¤£¥Î¥´¦¨
=vlookup(A1,A1:A100,5)

´¿¸g¬Ý¹L¦³¤H³o¼Ë¤l§@excelªí¡A·Q¾Ç¬Ý¬Ý

¦^´_ 1# zero20209

¦bsheet¥i¥H¥Î"=vlookup(12,©ú²Óªí¤@,2,false)"
¦bvbe´N­n¼g¦¨ a=worksheetfunction.vlookup(12,[©ú²Óªí¤@],2,false)
lmh

TOP

¥»©«³Ì«á¥Ñ owen06 ©ó 2013-8-6 09:44 ½s¿è

¦^´_ 1# zero20209


ª½±µ§â§A­n©w¸qªº½d³ò¥ý®Ø¿ï¦n¡AµM«á¦b¥ª¤W¨¤ªº¤è¶ô¦WºÙ¨º¡A
¿é¤J§A­nµ¹¥Lªº¦W¦r¡A³o¼Ë§A´N¥i¥H¨Ï¥Î§A©Ò»¡ªº¨º­Ó¥\¯à¤F¡A
­Y­n§ó§ï©w¸q¦WºÙªº½d³ò¡A¥h¡y´¡¤J¡z=>¡y¦WºÙ¡z=>¡y©w¸q¡z¡A
¸Ì­±¥i¥H½s¿è¡C
¦Ó¥B©w¸q¦WºÙªº¦n³B¬O¥i¥H¸ó¤u§@ªí¡A´Nºâ¦b¤£¦P¤u§@ªí­n¨Ï¥Î¨º­Ó½d³ò¡A
¤]¥i¥Hª½±µ¥´¦WºÙ´N¦n¡A«e­±¤£¥²¦A¿é¤J"¤u§@ªí¦W!"¡A§A¥i¥H¸Õ¸Õ¡C

TOP

2013ª©¥»ªº¦b¤½¦¡->¦WºÙºÞ²z­û¤º·s¼W§Y¥i
¦P¼Ó¤W¤j¤j¤èªk

TOP

­ì¨Ó¬O¦b´¡¤J¸Ìªº¦WºÙ©w¸q
·PÁ¦U¦ìªº¸Ñµª
¤S¤W¤F¤@½Ò

TOP

        ÀR«ä¦Û¦b : ¦Y­W¤F­W¡B­WºÉ¤Ü¨Ó¡A¨ÉºÖ¤FºÖ¡BºÖºÉ´d¨Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD