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

[µo°Ý] À³¥Î¤U©Ô¿ï³æ§ä¹ïÀ³¸ê®Æ

[µo°Ý] À³¥Î¤U©Ô¿ï³æ§ä¹ïÀ³¸ê®Æ

½Ð°Ý¦bA2¡BB2¦³°µ¤U©Ô¿ï³æ¡A·í§Ú¿ï¨ú¹ïÀ³¤§ªk±ø¦WºÙ¤Î±ø¤å«á¡A­n¦p¦ó³]©w¤~¯à®Ú¾Ú©Ò¿ï±ø¤å¡A¦Û°Ê±q¸ê®Æ®wùاä¥X¹ïÀ³ªº«O¦s¦~­­©M³Ì­«¥»¦D?ÁÂÁ¡I


¤U©Ô¿ï³æ.zip (7.47 KB)

¦^´_ 16# Hsieh

ÁÂÁ¶W¯Åª©¥D¡Aªþ¥ó¥i¥H¨Ï¥Î¡A¦Ó¥B¥i¥H¦Û°Ê©µ¦ùªk±ø¦WºÙ¤Î¬Û¹ïªº¤º®e¡A¯u¬O¤Ó´Î¤F¡I·PÁ±z¡I

TOP

¦^´_ 1# aer
¸Õ¸Õ¬Ý
¤U©Ô¿ï³æ.zip (9.65 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 14# softsadwind

ÁÂÁ±z´£¨Ñ¥t¤@ºØ¸Ñªk¡I

TOP

¦^´_ 13# aer

   °Ñ¦Ò¬Ý¬Ý....
   C2 =IF(A2=¬r«~±ø¤å,VLOOKUP($B2,¸ê®Æ®w!$E2:$G12,2),VLOOKUP($B2,¸ê®Æ®w!$A2:$C13,2))
   D2 ==IF(A2=¬r«~±ø¤å,VLOOKUP($B2,¸ê®Æ®w!$E2:$G12,3),VLOOKUP($B2,¸ê®Æ®w!$A2:$C13,3))
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 12# ML089

ÁÂÁª©¥D´£¨Ñ³o»ò´Îªº¤½¦¡¡A²¤Æ³\¦h¡A·PÁ±z¡I¨ü±Ð¤F

TOP

¦^´_ 10# aer

©êºp! ¨S¦³ª`·N¨ì³o°ÝÃD¡A¥i¥H¼W¥[¦WºÙ¤@¼Ë¥i¥H¨Ï¥Î¡C

¼W¥[¦WºÙ­×§ï¦p¤U:
¦Dªk±ø¤åDB        =¸ê®Æ®w!$A$2:$C$13
¬r«~±ø¤åDB        =¸ê®Æ®w!$E$2:$G$12

C2¤½¦¡¥i¥H²¤Æ¦p¤U:        
C2 =VLOOKUP($B2,INDIRECT($A2&"DB"),COLUMN(B2),)
¥k©Ô½Æ»s¤½¦¡
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_  ML089

ÁÂÁª©¥D´£¨Ñªº¤èªk¡A¦ý¬O¦bB2ªº¤U©Ô¦¡¿ï³æ·|¥X²{©Ò©w¸q½d³òªº¥þ³¡¸ê®Æ¡A¦perr¹Ï¤ù¡A§Ú§Æ±æ ...
aer µoªí©ó 2014-1-26 09:48


ÁÂÁª©¥D¡A§Ú¤w¸Ñ¨M¤F¡I¤½¦¡¦p¤U¡G

C2=INDEX(¸ê®Æ,MATCH($B$2,INDIRECT($A$2),0),IF(RIGHT($A$2,1)*1=1,COLUMN($B$2),COLUMN($B$2)*2+1))
D2=INDEX(¸ê®Æ,MATCH($B$2,INDIRECT($A$2),0),IF(RIGHT($A$2,1)*1=1,COLUMN($B$2)+1,COLUMN($B$2)*2+2))

¤U©Ô¿ï³æ-F.rar (7.86 KB)

TOP

¦^´_ 9# ML089

ÁÂÁª©¥D´£¨Ñªº¤èªk¡A¦ý¬O¦bB2ªº¤U©Ô¦¡¿ï³æ·|¥X²{©Ò©w¸q½d³òªº¥þ³¡¸ê®Æ¡A¦perr¹Ï¤ù¡A§Ú§Æ±æ¦p¥¿½Tªº¹Ï¤ùµ²ªG¡A¤£ª¾¹D¬O§_¥i¥H¹F¦¨¡H©Î¬O¥u¯à¥Îª©¥Dªº«Øij¤èªk©O¡H½Ð«ü±Ð¡AÁÂÁÂ



TOP

¦^´_ 7# aer

¦WºÙ­×§ï¦p¤U:
¦Dªk±ø¤å        =¸ê®Æ®w!$A$2:$C$13
¬r«~±ø¤å        =¸ê®Æ®w!$E$2:$G$12

C2¤½¦¡¥i¥H²¤Æ¦p¤U:       
C2 =VLOOKUP($B2,INDIRECT($A2),COLUMN(B2),)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ±o²z­nÄǤH¡A²zª½­n®ð©M¡C
ªð¦^¦Cªí ¤W¤@¥DÃD