- ©«¤l
- 184
- ¥DÃD
- 45
- ºëµØ
- 0
- ¿n¤À
- 407
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN 7
- ³nÅ骩¥»
- office 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-8-19
- ³Ì«áµn¿ý
- 2024-11-1
|
¦^´_ pupai
¿ï¨ú¤u§@ªí2¤§A1:C16¡ACtrl+Shift+F3¡A¥H¡u³»ºÝ¦C¡v¬°¦WºÙ¡C
½Ð°Ñ¦Òªþ¥ó¡I
p212 µoªí©ó 2014-6-10 12:26
쥻·Q»¡¨Ï¥Î VLOOKUP ¨ç¼Æ¨Ó¸Ñ¨M§Úªº°ÝÃD
¦ý¬O¨Ï¥Î VLOOKUP ¨ç¼Æ¡A¨C¦¸³£¥u¬O¦C¥X¬Û¦P¤º®eªº²Ä¤@µ§¡A¤£²Å¦X§Úªº»Ý¨D
ÁÂÁÂ坂¤j~~¦h¾Ç¨ì¤°»ò¬O"³»ºÝ¦C"
¥t¥~½Ð°Ý坂¤j
IF(SUMPRODUCT((Id=$A2)*(¤é´Á=$B2)*(¬ì¥Ø=C$1)*1),"*","")¤¤ªº"*1"¬O¤°»ò·N«ä
ÁÂÁÂ!! |
|