- ©«¤l
- 8
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 11
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office2013
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2019-3-14
- ³Ì«áµn¿ý
- 2019-4-23
|
[µo°Ý] ±a¤J²Å¦X¦h¶µ±ø¥ó«áªº¼ÆÈ
½Ð°Ýª©¤W¦U¦ì¤j¤j
·Qn¦bTESTªº¤u§@ªí¤¤,¦Û°Ê±a¤JDATA¤u§@ªí¤¤²Å¦X¦h¶µ±ø¥óªº¼ÆÈ,
Àx¦s®æC3¤¤¸ÕµÛ¥Î¤U¦Cªº¤½¦¡¨S¿ìªk±N¼Æȱa¤J,½Ð¦U¦ì«üÂI¤@¤U,ÁÂÁÂ!!
=IFERROR(INDEX(data!$C:$C,MATCH($A3&$B3&$C2,data!$B:$C,)+COLUMN(C3)),"0")
LISTªí®æ.zip (96.14 KB)
|
|