¤£¦P¤u§@ªí¤ºªº¸ê®Æ¤ñ¹ï»P¶ñ¤J.
- ©«¤l
- 77
- ¥DÃD
- 11
- ºëµØ
- 0
- ¿n¤À
- 118
- ÂI¦W
- 0
- §@·~¨t²Î
- winXP
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-12-24
- ³Ì«áµn¿ý
- 2011-3-2
|
¥»©«³Ì«á¥Ñ asus103 ©ó 2011-1-9 17:45 ½s¿è
©óSHEET 1 ªºD1¤¤¼g¤J
=IF(ISERROR(VLOOKUP(A1,Sheet2!A:B,2,FALSE)),"",VLOOKUP(A1,Sheet2!A:B,2,FALSE))
¦A¦V¤U©Ô |
|
ASUS
|
|
|
|
|
- ©«¤l
- 77
- ¥DÃD
- 11
- ºëµØ
- 0
- ¿n¤À
- 118
- ÂI¦W
- 0
- §@·~¨t²Î
- winXP
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-12-24
- ³Ì«áµn¿ý
- 2011-3-2
|
¦^´_ 10# Hsieh
Hsieh¤j¤j
¨C¤@¦¸¬Ý¨ì±z¹ïdictionary¨Ï¥Îªº¥X¯«¤J¤Æ¡AÁ`¬O§Ô¤£¦íÆg¹Ä
¦³¤@¬O½Ð±Ð
With Sheets(2)¤¤ªºEnd With¬°¦ó©ñ¨ì³Ì©³¤U©O?
¥i¥H©ñ¦bWith Sheets(1)¤§«e¶Ü? |
|
ASUS
|
|
|
|
|
- ©«¤l
- 77
- ¥DÃD
- 11
- ºëµØ
- 0
- ¿n¤À
- 118
- ÂI¦W
- 0
- §@·~¨t²Î
- winXP
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-12-24
- ³Ì«áµn¿ý
- 2011-3-2
|
¦^´_ 12# GBKEE
·PÁª©¥D¤j¤jªº¦^´_ |
|
ASUS
|
|
|
|
|