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

[µo°Ý] ¦p¦ó¥H¦h­ÓÄæ¦ì¬°¤ñ¹ï±ø¥ó¡A±N©Ò¹ïÀ³¨ìªº¸ê®Æ¦^¶Ç¶i·s³øªí

[µo°Ý] ¦p¦ó¥H¦h­ÓÄæ¦ì¬°¤ñ¹ï±ø¥ó¡A±N©Ò¹ïÀ³¨ìªº¸ê®Æ¦^¶Ç¶i·s³øªí

¥»©«³Ì«á¥Ñ daniel91276 ©ó 2011-3-14 12:11 ½s¿è

§Æ±æ¥i¥H¥t¥~°µ¤@¥÷³øªí¥H¨C­Ó¤H¤Î©ÒÄݪº±M®× ( ¦p: Jimi , 903CL0) ¬°¤ñ¹ï±ø¥ó
±N©Ò¹ïÀ³¨ìªº¸ê®Æ¦^¶Ç¶i·s³øªí


³sµ²¶i·s³øªí



©êºp  ¸É¤W°ÝÃDªºÀ£ÁYÀÉ
Test.zip (298.83 KB)

°Ý°ÝÃD½Ð¤W¶ÇexcelªºÀ£ÁYÀÉ.

TOP

¦^´_ 2# ANGELA


    ¤j¤j±z¦n¡A¤w¸É¤WÀ£ÁYÀÉ

TOP

¦]¬°³o°ÝÃD»Ý­n¤T¶µ±ø¥ó¥B¨ä¤¤¦³¨â­Ó±ø¥ó¬O¦b¦P¤@­ÓÀx¦s®æ¡A©Ò¥H¥Ø«eÁÙ·Q¤£¨ì¤èªk¸Ñ¨M
§Æ±æ¤j¤j­Ì¦³¤èªk³B²z  ·PÁÂ

TOP

=OFFSET(INDIRECT("["&C$4&".xls]b!a1"),MATCH(LOOKUP("öT",$A$5:$A6),MID(INDIRECT("["&C$4&".xls]b!a2:a176"),4,9),),3) °}¦C¤½¦¡

TOP

¥»©«³Ì«á¥Ñ ANGELA ©ó 2011-3-15 10:46 ½s¿è

«D±`·PÁÂ ANGELA ¤j¤j!!

§Ú­è­è¦³¸ÕµÛ§â¤½¦¡¥µ¶i¥h¦p¤U¹Ï¡A¥i¬O·|¥X²{#REP!¡A¦pªG§â"öT" §ï±¼«hÅܦ¨¤F N/A
¸Ô¦p¤U¹Ï



¥t¥~·Q½Ð°Ý¬õ®Ø³¡¤À¡A¤]´N¬O¤½¦¡³Ì«á  4,9),),3)  ªº·N«ä?
¨º¬OMID¨ç¼Æªº°Ñ¼Æ,4¬O±q²Ä¥|¦ì¶}©l,9¬O¨ú¤E¦ì.¥u­n¤j©ó¦r¦êªø«×¥¦·|¨ú¨ì³Ì«á¤@¦ì.

ÁÙ¦³µµ¦â®Ø¤¤¡A¤]´N¬O Leads  /  Apps  / Con.%  ³o¤T­Ó¼Æ­È¡A¤½¦¡­n¦p¦ó½Õ¾ã?
³o¸Ì¬Ý¤£¥X¤½¦¡µLªk²z¸Ñ,¦pªG­n¥h±¼¿ù»~¥i¥ÎIF§PÂ_.


¦A¦¸·PÁ±z!!

TOP

¥»©«³Ì«á¥Ñ ANGELA ©ó 2011-3-14 18:58 ½s¿è

=OFFSET(INDIRECT("["&C$4&".xls]b!a1"),MATCH(LOOKUP("öT",$A$5:$A6),MID(INDIRECT("["&C$4&".xls]b!a2:a176"),4,9),),MATCH($A$1,INDIRECT("["&C$4&".xls]b!b5:l5"),))
öT«e¦h¤F¤@­ÓªÅ®æ,¥h±¼¥¦.©Î¥ÎCHAR(65535)¨ú¥N öT

TOP

§ï¥Î´¶³q¤½¦¡VLOOKUP¤ñ¸û¦n
=VLOOKUP(C$4&$A6,INDIRECT("["&C4&".xls]b!a1:L176"),MATCH($A$1,INDIRECT("["&C$4&".xls]b!A5:l5"),),)

TOP

¥»©«³Ì«á¥Ñ daniel91276 ©ó 2011-3-15 16:42 ½s¿è

¦^´_ 8# ANGELA

«D±`·PÁ ANGELA ª©¥D¡A¥Ø«e¨Ï¥Î±z©Ò«Øij¤ñ¸û²³æ VLOOKUP ªº¤½¦¡¡A¤w¦¨¥\±N ³]©w±ø¥ó³Ì±µªñªº¼Æ­È¦^¶Ç¨ì³øªí¤¤

²{¦b¸I¨ìªº°ÝÃD¬O§Æ±æ¯à¦A¼W¥[±ø¥ó¡A¨Ì·Ó­ì¥»¤T­Ó±ø¥ó¦A¤ñ¹ï¤U¹Ï¤¤¬õ¦â¤Îµµ¦â½bÀYªº¤å¦r¨Ó¦^¶Ç¼Æ­È



¬õ¦â½bÀY
     

¦^¶Ç¨ì

   






µµ¦â½bÀY
   

¦^¶Ç¨ì





¥t¥~²{¦b¦pªG­n¨Ï¼Æ­È¦^¶Ç¡A»Ý±N©Ò¦³ªº­ì©l¸ê®ÆÀɳ£¶}±Ò¡A
·Q½Ð±Ð¬O§_¦³¿ìªk¦b­ì©l¸ê®ÆÀÉ®×Ãö³¬ªº±¡ªp¤U¥H¦Û°Ê§ó·sªº¤è¦¡³sµ²¨Ó¦^¶Ç¼Æ­È¡H

TOP

­n¥ÎINDIRECT´N­n¥´¶}°Ñ·Óªº¤u§@ï.
¦pªG¤@©w­n¥Î¦X¨Ö®æ,¥i±NA6,A7,A8³£¿é¤JCL0,¦A¦b¨ä¥¦ªÅ¥Õªº®æ¤l°²³]¬OAA6,AA7,AA8¦X¨Ö¦A¥Î®æ¦¡¨ê¨êA6,A7, A8§Y¥i.³o¼Ë´N¥i¥ÎVLOOKUP¤F.¥Î7¼Óªº¤½¦¡¥i¥H¤£§ï¦X¨Ö®æ.

TOP

        ÀR«ä¦Û¦b : «H¤ß¡B¼Ý¤O¡B«i®ð¤TªÌ¨ã³Æ¡A«h¤Ñ¤U¨S¦³°µ¤£¦¨ªº¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD