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

[µo°Ý] ½Ð°Ý¦p¦óÅý¹ïÀ³ªº¶µ¥Ø±Ò°Ê!

[µo°Ý] ½Ð°Ý¦p¦óÅý¹ïÀ³ªº¶µ¥Ø±Ò°Ê!

¤j®a¦n

§Ú¦³¥H¤Uªº°ÝÃD,½Ð¦U¦ì¬Ý©xÀ°¦£¤F ÁÂÁÂ!
=VLOOKUP($H2,'E:\TEST\[Test.xls]¤u§@ªí1'!$A2:D5,3)
¨Ò¦p»¡ §Ú±ø½X¦bH2 ¹ïÀ³¨ì¤F Test.xlsªº A3 ,A3¬O­Ó¶WÁpµ² ¦³¿ìªkÅý¥L¦b¤£¬O¤â°Ê«öªºª¬ªp¤U ±Ò¥Î¶Ü? (¨Ò¦p¶W³sµ²¬OMP3ªº¦ì¸m)
ÁÙ¦³¦]¬°§Ú¬O·s¤â ©Ò¥H½Ð°Ý¸Ì­±ªº$²Å¸¹¥Nªíªº¬O? ¦]¬°§Ú§â$®³±¼ ¤åªkÁÙ¬O¦³§@¥Î!
ÁÂÁ¦U¦ìªº¸Ñµª!

"$"¬Oµ´¹ï°Ñ·Óªº·N«ä
$A1¦V¤U©ì¦²,·|¬O$A2,$A3,$A4,$A5,¦]¬°"1"«e­±¨S¦³µ´¹ï°Ñ·Ó²Å¸¹$,©Ò¥H·|§ïÅÜ
·í§A¦V¥k©ì¦²,·|¬O$A1,$A1,$A1,$A1,¦]¬°"A"«e­±¦³µ´¹ï°Ñ·Ó²Å¸¹$,·í©Ò¥H©ì¦²®É¤£·|§ïÅÜAªº¦ì¸m

¦b¤½¦¡¥þ³¡³B²z¦n¥H«á,¦³¨S¦³$¬O¨S¦³Ãö«Yªº
ÁÙ¨S³B²z¦n­n©ì¦²¨º§xÃø«×©Î½ÆÂø«×¥i¯à°ª¤@¨Ç
­ì«h¤WÀ³¸Ó­nªº­n«O¯d,¤]¤£­nµe³D²K¨¬
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¥»©«³Ì«á¥Ñ luhpro ©ó 2010-12-19 18:35 ½s¿è

¦^´_ 1# bluraycity

¤@¯ë¨Ó»¡¦bExcel¦w¸Ë«á¨S¦³¤â°Ê½Õ¾ã³]©w«e,
¥ô¤@Àx¦s®æ¤ºªº¼Æ­È¦³²§°Ê®É,
Excel ·|¦Û°Ê§ó·s»P¨ä¬ÛÃöÁp(´N¬O¨Ì¨ä¤º¤½¦¡ªº­pºâ·|¾É­P¨ä­È²£¥ÍÅÜ°Ê)Àx¦s®æªº¸ê®Æ.

§A¤]¥i¥H³z¹L¤â°Ê½Õ¾ã¦¹³]©w­È (¥HExcel 2003¬°¨Ò : ¤u¨ã->¿ï¶µ->­pºâ-> ÂI¿ï "¦Û°Ê", ¦pªþ¹Ï)
©ÎªÌ¬Oª½±µ«ö¤U§Ö³tÁä F9 ±j¨î Excel ¨Ì¦U­ÓÀx¦s®æ¤ºªº¤½¦¡,
­«·s­pºâ©Ò¦³¤u§@ªí¤ºªº¼Æ­È,
¨ºÀ³¥i¥H¹F¨ì§A·Q­nªºµ²ªG.

TOP

·PÁÂLUH¤j¤jªº«Øij §Ú±ßÂI¨Ó¸Õ¸Õ¬Ý ·PÁÂ!

TOP

¦^´_ 2# gong


¤]ÁÂÁª©¥Dªº¸Ô²Ó¸Ñµª ¤p§Ì¤w¸g¹ï$¦³¸Ô²Óªº¤F¸Ñ¤F

³o­Ó¯¸¯uªº«Ü¦n ·PÁ¦A·PÁÂ!

TOP

        ÀR«ä¦Û¦b : ¹ï¤÷¥À­nª¾®¦¡A·P®¦¡B³ø®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD