ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

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

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

½Ð°Ýª©¤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")

TEST

TEST.jpg
2019-4-20 14:01


LISTªí®æ.zip (96.14 KB)

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)),"")
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

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)),"")

TOP

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



   
ScreenHunter_04 Apr. 21 22.35.jpg
2019-4-21 22:37

TOP

¦^´_ 2# hcm19522
H¤j,
¼Æ­ÈÁÙ¬OµLªk±a¥X,¬O§Ú­þ¸Ì¦³§Ë¿ù¶Ü?
ScreenHunter_05 Apr. 21 22.42.jpg
2019-4-21 22:43

TOP

¦^´_ 5# ken88y


    ¼Æ²Õ¤½¦¡ :½Æ»s¤½¦¡ ¤£§t "=" ,¶K¤W«á¥[ "="   ;³Ì«e "{" ¥Nªí shift+ctrl+enter ¤TÁä¤@°_«ö©Ò²£¥Í ,«Dµ{¦¡¸Ì­±
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 5# ken88y


    A:A Äæ­^¤å¦r¥´¿ù¤F TSET1 §ï¬° TEST1¡A2 3 ¤@¼Ë
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥»©«³Ì«á¥Ñ ML089 ©ó 2019-4-22 14:13 ½s¿è

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¤½¦¡
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 8# ML089 ¦^´_ ­ã´£³¡ªL ªO¤j
¦^´_ hcm19522
¥i¥H±a¤J¼Æ­È¤F,¦hÁ¤T¦ìªº«ü¾É.
ScreenHunter_01 Apr. 23 00.43.jpg
2019-4-23 00:43

TOP

        ÀR«ä¦Û¦b : ¶¢¤HµL¼Ö½ì¡A¦£¤HµL¬O«D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD