[µo°Ý] ¦p¦ó¦b³]¦³¤½¦¡ªºÀx¦s®æ¶ñ¤J¼Æ¦r

kai6929

½Ð±Ð¦U¦ì¤j®v,¦p¦ó¦b³]¦³¤½¦¡ªºÀx¦s®æ¶ñ¤J¼Æ¦r,

¦pªþ¥ó
Kai_QA.rar (7.16 KB)

¤U¸ü¦¸¼Æ: 16

2010-5-8 22:29

kai6929

·PÁ¦U¦ì¤j®v,ªº«ü±Ð§Ú,¦ý¦pªG¬O¥ÎVBA¸Ó¦p¦óµÛ¤â

kai6929

¤F¸Ñ,·PÁ¦U¤j®vªº¶}¥Ü.

kai6929

¼Ó¥Dªº·N«ä¤£ª¾¬O§_¦p¦¹
°²³]§â³W®æªí©ñ¦bM1:R8
B7=VLOOKUP($A$7,$M$1R$10,COLUMN(),0)
Hsieh µoªí©ó 2010-5-8 15:17

·PÁ¦U¦ì¤j®vªº°Ñ»P
                    ¥H¤Î  Hsieh ¤j®v,§A¯u¤F¤º¦æ,³o´N¬O§Ú­nªº·N«ä,¦ý§Ú·Q§âvlookupªº¨ç¼Æ§ï¬°INDEX¨ç¼Æ¥i¥H¶Ü

kai6929

If Target = "A" Then [B7:F7] = "" Else [B7:F7].FormulaR1C1 =
"=VLOOKUP(R7C1,R1C13:R10C18,COLUMN(),0)"

½Ð±Ð¤@¤U¤j®v  (R7C1,R1C13:R10C18 ³o¸Ì¬O¤°»ò·N«ä

kai6929

·PÁ¦U¦ì¤j®v,
                         ³o¬O§Ú°µ¦nªº¦¨¥»¤ÀªR¸ò¤j®a¤À¨É¤@¤U
                              

¤U¸ü (104.12 KB)
¦¨¥»¤ÀªR

2010-5-11 10:29