- ©«¤l
- 21
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 61
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- taichung
- µù¥U®É¶¡
- 2010-11-22
- ³Ì«áµn¿ý
- 2015-4-13
|
¥»©«³Ì«á¥Ñ oobird ©ó 2011-8-8 21:18 ½s¿è
°²³]sheet2:§@¬°«È¤á¥X³f¬y¤ô±b¥Î,¨Ã¼W¦CY¤z«~¶µÄæ¦ì.¤wkey§¹¨Ã¼W¦C«~¶µÄæ©óF(«~¶µA).G(«~¶µB).H(«~¶µC).I(«~¶µD).¥|Äæ,·íµM¼Æ¶qÈF4=1,G4=2,H4=3,I4=4
sheet1:§@¬°¬d¸ß+¦C¦Lªí³æ¥Î(¥unkey-Àx¦s®æ:G4=1003
±z»Ý¨D¦pE10=IF(ISNA(VLOOKUP($G$4',sheet2!$A$2:$J$10,5,FALSE)),0,VLOOKUP($G$4',sheet2!$A$2:$J$10,5,FALSE)) ¨ä¥¦Äæ¦ì¥ç¥i¥Î°Ñ·Ó¨ç³N¦Û°Ê²£¥Í) |
|