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

[µo°Ý] ·j´M¹ïÀ³­Èªº¨ç¼Æ¤½¦¡

[µo°Ý] ·j´M¹ïÀ³­Èªº¨ç¼Æ¤½¦¡

¥¼©R¦W.png
2019-9-3 18:11

»Ý¨D¡J
1_±NB9:I9=$AQ$3­Èªº²Ä2¦C¦PÄæ­ÈÅã¥Ü¦bAR3¡C
2_±NB9:I9=$AS$3­Èªº²Ä2¦C¦PÄæ­ÈÅã¥Ü¦bAT3¡C

PS¡J¦pªG¦³2­Ó(§t)¥H¤Wªº¹ïÀ³¼Æ¡A«h¥H","°Ï¹j¡C

¤£¦n·N«ä¡A¨Ï¥ÎINDEX+MATCH¨ç¼Æ¸Ñ¡A¥u¯à±a¥X²Ä1­Ó­È¡C

¸Û½Ð¦U¦ì¤j¤j½ç±Ð! ÁÂÁ¦U¦ì!

´ú¸ÕÀÉ : ·j´M¹ïÀ³­Èªº¨ç¼Æ¤½¦¡.rar (5.74 KB)

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 2# hcm19522
·PÁ±zªº¦^ÂÐ^^
¦ý§Úªº°ÝÃD´N¬O·í¦pªG¦³2­Ó(§t)¥H¤Wªº¹ïÀ³¼Æ®É¡A«h¥H","°Ï¹j¥þ³¡Åã¥Ü¡C
¤£ª¾¬O¤£¬O¨ç¼Æ¸ÑµLªk¦b¦P¤@­ÓÀx¦s®æÅã¥Ü2­Ó¥H¤Wªº­È?
¸Û½Ð½ç±Ð!ÁÂÁ±z!

TOP

¦^´_ 2# hcm19522
AR3=INDEX($B$2:$I$2,MATCH(AQ3,$B$9:$I$9,0))   =>AR3=30
AT3=INDEX($B$2:$I$2,MATCH(AS3,$B$9:$I$9,0))     =>AT3=14
AV3=INDEX($B$2:$I$2,MATCH(AU3,$B$9:$I$9,0))     =>AV3=21
½Ð°Ý :
­n¦p¦ó­×¥¿¤½¦¡~
ÅýAR3=30     AT=14,02        AV3=21,22
ÁÂÁ±z!

TOP

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2019-9-5 10:11 ½s¿è

¦^´_ 4# ziv976688


    ¥Ø«e2007ª©µL¦¹«ü¥O  ©Òª¾À³2016ª©¦³  

http://blog.xuite.net/hcm19522/twblog Ãþ¦üÃD«Ü¦h "¬Û¦P»E©ó³æ¤¸®æ"
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2019-9-5 11:23 ½s¿è

¦^´_ 5# hcm19522
ÁA¸Ñ¤F~2003ª©ªº¨ç¼ÆµL¸Ñ^^"
¥u¯à¥HVBA¸É±Ï¡C
·PÁ¤j¤jªº­@¤ß¦^ÂÐ~·P®¦^^
================================
¤£¦n·N«ä¡A³o¤@ÃD     http://forum.twbts.com/thread-22039-1-1.html
¯à§_«_¬N½Ð±zÄ~Äò½ç±Ð?
¦A¦¸ÁÂÁ±z^^

TOP

        ÀR«ä¦Û¦b : ¨C¤ÑµL©Ò¨Æ¨Æ¡A¬O¤H¥Íªº®ø¶OªÌ¡A¿n·¥¡B¦³¥Î¤~¬O¤H¥Íªº³Ð³yªÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD