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

[µo°Ý] VLOOKUP 0¶}©lªº½s¸¹

[µo°Ý] VLOOKUP 0¶}©lªº½s¸¹

¥»¤H¦b¹q¸£¨t²Î¤¤¿é¥X­û¤u¸ê®Æ, ­û¤u½s¸¹¬O001213 (¤å¦r), ¥ÎVLOOKUP¹ï·Ó®É, «o¥uÅã¥Ü1213, ©Ò¥H¥¼¯à¹ï·Ó¥t¤@¥÷­û¤u¸ê®Æ (¦]¬°¥t¤@¥÷¤£¬O¹q¸£¨t²Î¿é¥Xªº­û¤u½s¸¹¬O001213ªº¤å¦r)
§Ú¸Õ¥Î--¦ý³£¨S¦³¥Î, ½Ð±Ð¥i¥H«ç¼Ë³B²z?

½Ð«ü±Ð!

¦^´_ 1# mariabb

³o­Ó³Ì¦n¬Oªþ­ÓÀÉ®×
¤ñ¸û¯à¬Ý¥X°ÝÃD¥X¦b­þ¸Ì

TOP

¥»©«³Ì«á¥Ñ mariabb ©ó 2013-6-21 16:55 ½s¿è

VLOOKUP SAMPLE.rar (8.28 KB) ¦^´_ 2# Bodhidharma

¦³³Ò¸Ñµª!:'(

TOP

¦^´_ 3# mariabb

Sheet1!A2ªº29¬O¥Î¤½¦¡¹ï·Ó¥X¨Óªº¶Ü¡H¦pªG¬Oªº¸Ü¡A¥i¥H¥ÎTEXT(­ì¤½¦¡,"000000")±N¤§Âà´«¬°¤å¦r

TOP

¦^´_ 3# mariabb

§âsheet1 ªºA2Àx¦s®æ®æ¦¡§ï¦¨¤å¦r ¼Æ­È´NÅܦ¨29
¦b29«e­±¸É¤W000 §Aªº¤½¦¡´N¦¨¥ß

¤]´N¬O»¡ID ¨º¤@Ä檺®æ¦¡³£¥Î¤å¦r...À³¸Ó´N¥i¥H¸Ñ¨M
try it
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 5# softsadwind


    :'( ¦]¬°Àɮפº¥þ¬O5­Ó¦ìªº¼Æ¦r²Õ¦X, ¦³00001,00011,00111©Î01111µ¥,¦³¨S¦³¨ç¼Æ¥i¥H¦P®É³B²z³o¦h¼Ë²Õ¦X?
¦³³Ò!:loveliness:

TOP

¦^´_ 6# mariabb

§A´£¨ÑªºÀɮרӬÝ
    sheet1 A2.png
½Ðª`·N¬Ýsheet1ªºA2 ÁöµM¥L¬OÅã¥Ü00029 ¦ý¬O¥L¹ê»Úªº¼Æ­È¬O29 ¡A¥u¬OÅã¥Üªº®æ¦¡¥Î¯S®íªº¤è¦¡¤~Åã¥Ü¦¨¬°00029

sheet2 A2.png
¦Ósheet2ªºA2 ´N¬Oª½±µ¬O¥Î¤å¦rÅã¥Ü00029

§A¥Î¤å¦r®æ¦¡ªº00029¥hvlookup ¼Æ­È®æ¦¡ªº29 ªÖ©w¬O§ä¤£¨ì...
«Øij§A¥ÎBodhidharma ªº¤½¦¡¥h§ïÅܭ쥻ªºIDÄæ¦ì
§ä¤@­ÓªÅ¥ÕÄæ F2= text( A2,"00000")  ¤U©Ô«á½Æ»s"­È"¨ìAÄæ
³o¼Ë¤l¾ãÄ檺ID³£·|§ï¦¨¤å¦r®æ¦¡

¨ä¥L¤À­¶ªºID ¦P²z¥h±À...
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 7# softsadwind


    ¶â ²³æ¤@ÂI»¡¦n¤F §â§Aªºsheet2ªºÄæ¦ì®æ¦¡ §ï¦¨¶l»¼°Ï¸¹  ³o¼Ë¤lªº®æ¦¡©Msheet1ªº®æ¦¡¬O¤@¼Ë ´Nºâ¥´29 ¨â­Ó³£·|Åã¥Ü000029  A3ªºvlookup¤½¦¡¤]¥i¥H¥¿±`¨Ï¥Î

201306261419 002.png
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : ¡i¦æµ½­n¤Î®É¡j¦æµ½­n¤Î®É¡A¥\¼w­n«ùÄò¡C¦p¿N¶}¤ô¤@¯ë¡A¥¼¿N¶}¤§«e¤d¸U¤£­n°±º¶¤õ­Ô¡A§_«h­«¨Ó´N¤Ó¶O¨Æ¤F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD