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

¦p¦ó¨Ì¤T¨µ¶×²v¤Î¤£¦Pªº¹ô§Oºâ¥X¬üª÷ª÷ÃB

¦p¦ó¨Ì¤T¨µ¶×²v¤Î¤£¦Pªº¹ô§Oºâ¥X¬üª÷ª÷ÃB

¦p¦ó¨Ì¤T¨µ¶×²vºâ¥X¬ü¤¸ª÷ÃB.rar (68.03 KB)

½Ð±Ð: ¨Ì¨C¤ë¤T¨µ¶×²v¤Î¤£¦P¹ô§Oª÷ÃBºâ¥X¬üª÷ª÷ÃBªº¨ç¼Æ¦p¦ó¼g?

·PÁÂ!!
fangac

¥»©«³Ì«á¥Ñ kimbal ©ó 2012-7-22 11:41 ½s¿è

H4 ªº¤½¦¡, ¦V¤U§Û§Y¥i
=G4/VLOOKUP(C4,$J$4:$P$24,MATCH(F4,$K$3:$P$3,0)+1,TRUE)


¤é´ÁÃöÁä¦b©óVLOOKUP¤WªºTRUE
MATCH(F4,$K$3:$P$3,0)+1 ¥Î¨Ó§ä¹ïÀ³¹ô­È
MATCH(F4,$J$3:$P$3,0) ³o¼Ë¤]¥i¥H
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

¦^´_ 2# kimbal

·PÁ§Aªº¦^ÂлP±Ð¾É.
MATCH(F4,$K$3:$P$3,0)+1  
½Ð±Ð:  ¬°¤°»ò«á­±­n  "+1" ?  
§Úªº²Â¸£³U·Q¤£¤ÓÀ´.

Thanks.
fangac

TOP

¦^´_ 3# fangsc


    MATCH(F4,$K$3:$P$3,0)+1  
±o¨ìªº­È¬O­n°µ¬°VLOOKUP(C4,$J$4:$P$24,MATCH(F4,$K$3:$P$3,0)+1,TRUE)
¦ì²¾°Ñ¼Æ¥Îªº¡A¥HTWD¬°¨Ò¡AMATCH(F4,$K$3:$P$3,0)  ±o¨ìªº­È¬O1,VLOOKUP¤¤,°Ñ¼Æ1¬O¨ú²Ä¤@Äæ¡A²{¦b­n¨ú²Ä¤GÄæ¡A©Ò¥H­n¥[1¡C

TOP

¦^´_ 4# ANGELA

¤F¸Ñ¤F. ·PÁ§A²Ó¤ßªº¸Ñ»¡.

Thanks.
fangac

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2012-7-27 11:12 ½s¿è

H4
=G4/VLOOKUP(C4,J$3:P$24,MATCH(F4,K$3:P$3,)+1)
OR
=G4/INDEX(K$4:P$24,MATCH(C4,J$4:J$24),MATCH(F4,K$3:P$3,))

TOP

        ÀR«ä¦Û¦b : ¡i¬°µ½Ävª§¡j¤H¥Í­n¬°µ½Ävª§¡A¤À¬í¥²ª§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD