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

[µo°Ý] ¦pªG¹J¨ì¨âºØ¶µ¥Ø­n¿z¿ï¸Ó¥Î­þºØ¨ç¼Æ?

[µo°Ý] ¦pªG¹J¨ì¨âºØ¶µ¥Ø­n¿z¿ï¸Ó¥Î­þºØ¨ç¼Æ?

§Ú¥ÎVLOOKUP ¥u¯à¿z¿ï¤@ºØ  

¦ý¬O¹J¨ì¨âºØ¸Ó¦p¦ó¨Ï¥Î??

¸÷¨D°ª¤â

¨Ï¥ÎVLOOKUP µLªk¿z¿ï.ZIP (69.27 KB)



¦^´_ 1# keovin790916


½Ð¸Õ¸Õ¬Ý.

¬¡­¶Ã¯1.rar (59.08 KB)

TOP

¨º¨ç¼Æ¦p¦ó¨Ï¥Î???  


¯à±Ð¾É¤@¤U??  ·P®¦±z

TOP

¦^´_ 3# keovin790916


½Ð°Ñ¾\...

http://office.microsoft.com/zh-tw/excel-help/HP005209138.aspx

TOP

¥»©«³Ì«á¥Ñ GBKEE ©ó 2013-3-16 15:50 ½s¿è

¦^´_ 4# lukychien
=INDEX($C$32:$M$37,Q27:V27,$O29:$O39)
³oQ27:V27,$O29:$O39¬O»²§Uªº°Ñ·Ó, ¦p¬d¬Ý«~¶µ¦³­×§ï¤£·|¸òµÛÅÜ°Ê

¦^´_ 3# keovin790916
¸Õ¸Õ¬Ý


TEST.rar (7.27 KB)
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¯uªº¬O°ª¤â¡C


ÁÂÁ±z­Ì¡C

TOP

¦^´_ 6# keovin790916
¼Ï¯Ã¤ÀªR
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¤£¹L §Ú®M¥Î¤W¥hÁÙ¬O¨S¿ìªk¡C ³o¬O«ç»ò¦^¨Æ

TOP

³Â·Ð¤j¤jÀ°§Ú¬Ý¤@¤U



§Ú·Q½Ð°Ý¤@¤U³o¬O«ç»ò¦^¨Æ¡C


¬°¤°»òÁÙ¬O¨S¿ìªk¿z¿ï¹L¨Ó

¨D¸Ñ¡C.rar (6.2 KB)

TOP

¦^´_ 9# keovin790916

½Ð¦A¸Õ¸Õ¬Ý

¨D¸Ñ.rar (5.36 KB)

TOP

        ÀR«ä¦Û¦b : ¤£­nÀH¤ß©Ò±ý¡A­nÀH¤ß±Ð¨|¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD