¦p¦ó¨Ì¤T¨µ¶×²v¤Î¤£¦Pªº¹ô§Oºâ¥X¬üª÷ª÷ÃB
- ©«¤l
- 81
- ¥DÃD
- 27
- ºëµØ
- 0
- ¿n¤À
- 151
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- ¨Ó¦Û
- Taiwan
- µù¥U®É¶¡
- 2012-6-7
- ³Ì«áµn¿ý
- 2020-11-27
|
¦p¦ó¨Ì¤T¨µ¶×²v¤Î¤£¦Pªº¹ô§Oºâ¥X¬üª÷ª÷ÃB
|
fangac
|
|
|
|
|
- ©«¤l
- 472
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 485
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows
- ³nÅ骩¥»
- MS Office
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- »´ä
- µù¥U®É¶¡
- 2010-7-4
- ³Ì«áµn¿ý
- 2014-12-28
|
¥»©«³Ì«á¥Ñ 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 |
|
|
|
|
|
|
- ©«¤l
- 81
- ¥DÃD
- 27
- ºëµØ
- 0
- ¿n¤À
- 151
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- ¨Ó¦Û
- Taiwan
- µù¥U®É¶¡
- 2012-6-7
- ³Ì«áµn¿ý
- 2020-11-27
|
¦^´_ 2# kimbal
·PÁ§Aªº¦^ÂлP±Ð¾É.
MATCH(F4,$K$3:$P$3,0)+1
½Ð±Ð: ¬°¤°»ò«á±n "+1" ?
§Úªº²Â¸£³U·Q¤£¤ÓÀ´.
Thanks. |
|
fangac
|
|
|
|
|
- ©«¤l
- 812
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 862
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2010-5-13
- ³Ì«áµn¿ý
- 2019-10-10
|
¦^´_ 3# fangsc
MATCH(F4,$K$3:$P$3,0)+1
±o¨ìªºÈ¬On°µ¬°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²{¦bn¨ú²Ä¤GÄæ¡A©Ò¥Hn¥[1¡C |
|
|
|
|
|
|
- ©«¤l
- 81
- ¥DÃD
- 27
- ºëµØ
- 0
- ¿n¤À
- 151
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- ¨Ó¦Û
- Taiwan
- µù¥U®É¶¡
- 2012-6-7
- ³Ì«áµn¿ý
- 2020-11-27
|
¦^´_ 4# ANGELA
¤F¸Ñ¤F. ·PÁ§A²Ó¤ßªº¸Ñ»¡.
Thanks. |
|
fangac
|
|
|
|
|
- ©«¤l
- 206
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 218
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN10
- ³nÅ骩¥»
- OFFICE 365
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW¥x¥_
- µù¥U®É¶¡
- 2010-5-15
- ³Ì«áµn¿ý
- 2023-6-18
|
¥»©«³Ì«á¥Ñ 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,)) |
|
|
|
|
|
|