[µo°Ý] ±a¤J²Å¦X¦h¶µ±ø¥ó«áªº¼Æ­È

ken88y

½Ð°Ýª©¤W¦U¦ì¤j¤j
·Q­n¦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")

¤U¸ü (101.99 KB)
TEST

2019-4-20 14:01

LISTªí®æ.zip (96.14 KB)

¤U¸ü¦¸¼Æ: 11

2019-4-20 14:03

hcm19522

C3:F8{=IFERROR(INDEX(data!$C:$C,MATCH(1=1,LOOKUP("¼_",$A$3:$A3)&$B3=data!$C$8:$C$99&data!$C$4:$C$95,)+CHOOSE(COLUMN(A1),8,10,11,12)),"")

­ã´£³¡ªL

C3/°}¦C¤½¦¡:
=iferror(INDEX(data!$C:$C,MATCH($B3&$A2&$A3,data!$C$1:$C$299&data!$C$5:$C$299,)+COLUMN(A$1)+5-($C$2=C$2)),"")

ken88y

¦^´_ 3# ­ã´£³¡ªL ªO¤j
¸Õ¤F¤@¤U,µo²{­ÈÁÙ¬OµLªk±a¥X,­×§ï¤F°Ñ·ÓªºÀx¦s®æ,ÁÙ¬OµLªk±N­È±a¥X

¤U¸ü (72.94 KB)

2019-4-21 22:37

   

¤U¸ü (75.53 KB)

2019-4-21 22:37

ken88y

¦^´_ 2# hcm19522
H¤j,
¼Æ­ÈÁÙ¬OµLªk±a¥X,¬O§Ú­þ¸Ì¦³§Ë¿ù¶Ü?

¤U¸ü (85.88 KB)

2019-4-21 22:43

hcm19522

¦^´_ 5# ken88y


    ¼Æ²Õ¤½¦¡ :½Æ»s¤½¦¡ ¤£§t "=" ,¶K¤W«á¥[ "="   ;³Ì«e "{" ¥Nªí shift+ctrl+enter ¤TÁä¤@°_«ö©Ò²£¥Í ,«Dµ{¦¡¸Ì­±

ML089

¦^´_ 5# ken88y


    A:A Äæ­^¤å¦r¥´¿ù¤F TSET1 §ï¬° TEST1¡A2 3 ¤@¼Ë

ML089

C3:F4 °Ï°ì°}¦C

¥ý¿ï¾Ü C3:F4 Àx¦s®æ2X4®æ¡A½s¿èÄæ¶K¤W¤½¦¡¡A°}¦C¤½¦¡¤TÁä¿é¤J(¥ý«ö¦í CTRL+SHIFT¤£©ñ¡A¦A«öENTER¿é¤J¤½¦¡)
=IFERROR(INDEX(data!C:C,MATCH(A3&IF({1;0},B3,B4),data!C$8:C$98&data!C$4:C$94,)+7+{1,3,4,5}),"")

¿ï¾Ü C3:F4 Àx¦s®æ2X4®æ¡A¥k¤U¶ÂÂI¤U©Ô½Æ»s¤½¦¡

ken88y

¦^´_ 8# ML089 ¦^´_ ­ã´£³¡ªL ªO¤j
¦^´_ hcm19522
¥i¥H±a¤J¼Æ­È¤F,¦hÁ¤T¦ìªº«ü¾É.

¤U¸ü (45.62 KB)

2019-4-23 00:43