- ©«¤l
- 190
- ¥DÃD
- 16
- ºëµØ
- 0
- ¿n¤À
- 236
- ÂI¦W
- 291
- §@·~¨t²Î
- windows xp
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-8-8
- ³Ì«áµn¿ý
- 2024-11-28
|
¦^´_ kai6929
=INDEX(°Ï°ì¶O²v!B:H,MATCH(E4,°Ï°ì¶O²v!B:B,0),MATCH(E3,°Ï°ì¶O²v!3:3,0))
Hsieh µoªí©ó 2012-11-5 12:12
½Ð°Ý¤@¤Uª©¥D·í§Ú®M¥Î¦¹¤½¦¡¡A¥un¥Øªº°ê¿ï¾Ü"¤é¥»"¡A¤£½×¥Xµo¦a¬O¨º¤@¿¤¥«¡AE6µ²ªG¬Ò¥X²{¿ù»~È #REF!¡C¦pªG§â¤½¦¡×§ï¦p¤U¦¡¡A«hµ²ªG¥¿±`
=INDEX(°Ï°ì¶O²v!B:H,MATCH(E4,°Ï°ì¶O²v!B:B,0),MATCH(E3,°Ï°ì¶O²v!3:3,0)-1)
½Ð°Ý³o¬O¤°»ò°ÝÃD?¬°¤°»ò·|³o¼Ë©O?ÁÂÁ«ü¾É |
|