- ©«¤l
- 522
- ¥DÃD
- 36
- ºëµØ
- 1
- ¿n¤À
- 603
- ÂI¦W
- 0
- §@·~¨t²Î
- win xp sp3
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-12-13
- ³Ì«áµn¿ý
- 2021-7-11
|
¦^´_ 1# j88141
Excel 2003 ªº§@ªk:
1. ¿ï¨ú ¤u§@ªí2 F1:F10
2. ¦b¸ê®Æ½s¿è¦C¤¤¿é¤J¤½¦¡¡G
=IF(ISERROR(VLOOKUP(B1:B10&C1:C10,¤u§@ªí1!A1:A10&¤u§@ªí1!B1:B10,1,0)),"","¿é¤J§¹¦¨")
3. «ö CTRL+SHIFT+ENTER Áä¡C
Excel 2007+ ¥t½Ð°ª©ú |
|