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

¦p¦ó±a¸ê®Æ®w¸ê®Æ

¦p¦ó±a¸ê®Æ®w¸ê®Æ

½Ð°Ý­n¦p¦ó±a¸ê®Æ®w¸Ìªº¸ê®Æ
¦pa1¬O¥N½X¡Ab1¬O¦WºÙ¡Ac1¬O¹q¸Ü¡Ad1¬O¦a§}¡Kµ¥
§Ú¥u­n¥´¥N½X¡A«á­±ªºb1¡Ac1¡Ad1¡K´N·|¦Û°Êªº§â¸ê®Æ±a¶i¥h¡A¤£¥Î¤@ª½¥´­«ÂЪº¸ê®Æ©O??
¦U¦ì¤j¤j±Ð±Ð§Ú§a¡AÁÂÁÂ

vlookup()À³¸Ó¬O¤£¿ù¥Î,¦Ó¥B¬O©öÀ´¨ç¼Æ
¦Û¤v°Ñ¦Ò»¡©ú¸ÕµÛ¦Û¤v¾Þ§@¬Ý¬Ý
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¦^´_ 2# gong


    §Ú¦³¬Ý¤F»¡©ú¡A¦ý¬O¤£¦Pªº¸ê®ÆÀɮסA­n«ç»ò°µ©O

TOP

¤G­ÓÀɮ׳£¶}µÛ
b2=VLOOKUP($A2,[Book2.xls]Sheet1!$A$2:$D$5,2,0)
·íbook2.xlsÃö³¬®É
b2=VLOOKUP($A2,'C:\Documents and Settings\HT1\My Documents\[Book2.xls]Sheet1'!$A$2:$D$5,2,0)

vlookup¬°«D©ö¥¢©Ê¨ç¼Æ,·íÃö³¬³sµ²Àɤ´¥i¨ú±o¸ê®Æ,ºÝ¬Ý¬O§_­n§ó·s¸ê®Æ
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¤G­ÓÀɮ׳£¶}µÛ
b2=VLOOKUP($A2,Sheet1!$A$2D$5,2,0)
·íbook2.xlsÃö³¬®É
b2=VLOOKUP($A2,'C:\Document ...
gong µoªí©ó 2010-11-15 23:11



    §ÚÀ´¤F¡A«D±`·PÁ±zªº«ü±Ð¡AÁÂÁÂ


¥t½Ð°Ý¡A¦pªG¬O¤U©Ô¦¡¿ï¶µ«á¤]¥i³o¼Ë±a¤J¸ê®Æ¶Ü??

TOP

¤U©Ô¦¡¿ï³æ¤£¯à¸ó¤u§@ªí¨Ï¥Î
­n¨Ï¥Î©w¸q¦WºÙ
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

·íÃö³¬³sµ²Àɤ´¥i¨ú±o¸ê®Æ,ºÝ¬Ý¬O§_­n§ó·s¸ê®Æ
­ì¨Ó¤]¥i¥H³o¼Ë
hango

TOP

¥ÎVLOOKUP¬O¥i¥H¤ñINDIRECT§óª½±µ. ¦ý¦p§Ú¥u·Q­n¦bb2 ¹ïÀ³BOOK 2.XLS SHEET 1¤¤DÄæ¨ä¤¤¤@®æªº¸ê®Æ®É, INDIRECT¬O§_·|¤ñ¸û¦X¥Î?

TOP

¥ÎVLOOKUP¬O¥i¥H¤ñINDIRECT§óª½±µ. ¦ý¦p§Ú¥u·Q­n¦bb2 ¹ïÀ³BOOK 2.XLS SHEET 1¤¤DÄæ¨ä¤¤¤@®æªº¸ê®Æ®É, INDIR ...
Leo1318 µoªí©ó 2015-5-3 13:53


­YB2¥N½X¬O§Ç¸¹®É¡A¥i¥H¨Ï¥ÎINDIRECT©ÎOFFSETª½±µ¥H¥N½X°µ¬°°¾²¾¶q¨ú±o¸ê®Æ¡A·íµM·|¤ñVLOOKUP§ó§Ö³t¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

b2=VLOOKUP($A2,[Book2.xls]Sheet1!$A$2D$5,2,0)
b1¡Ac1¡Ad1¡K´N·|¦Û°Êªº§â¸ê®Æ¾î¦V±a¶i¥h.  ¦ý¦p·Q§â¸ê®Æ¦V¤U¤è±a¶i¥h (¦pA1,A2,A3,A4....), ¬O§_¥i¥Hªº¶Ü?

TOP

        ÀR«ä¦Û¦b : ª¾ÃÑ­n¥Î¤ßÅé·|¡A¤~¯àÅܦ¨¦Û¤vªº´¼¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD