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

[µo°Ý] ¦p¦ó¥ÎIF©MVLOOKUP¨ç¼Æ¦P®É¬d§ä¨â­Ó¯S©w¤å¦r

[µo°Ý] ¦p¦ó¥ÎIF©MVLOOKUP¨ç¼Æ¦P®É¬d§ä¨â­Ó¯S©w¤å¦r

¥»©«³Ì«á¥Ñ ciara76190 ©ó 2017-6-7 15:38 ½s¿è



G2®æ¤ºªº¨ç¼Æ¬°
=IF(VLOOKUP(A2,´£³æ©ú²Ó!$B$3:$S$968,10,FALSE)="¤ëµ²",0,VLOOKUP(A2,´£³æ©ú²Ó!$B$3:$S$968,10,FALSE))
(´£³æ©ú²Ó¤¤¦³¤TºØ¥I´Ú¤è¦¡ 1.¤ëµ² 2.¶×´Ú 3.ª÷ÃB (¼Æ¦rEX:1000¡B2500¡B5500)

¥Ø«e³o­Ó¥u¯à°÷¸Ñ¨M±¼ ¡u¦pªG¥I´Ú¤è¦¡¬°"¤ëµ²" Åã¥Ü¥N¦¬´Ú¬°0¡vªºª¬ªp
¹ï©ó¨ç¼ÆªºÀ³¥Î©M²z¸Ñ§ÚÁÙ¥u¬O¤Jªùµ{«×
¾¨ºÞ¦Û¤vª¦¤å¸ÕµÛ§ï¼g¤F«Ü¦h¦¸ ¸Õ¹LIF¡BIFERROR¡BAND¡BORµ¥µ¥³£ÁÙ¬O¥¢±Ñ...

½Ð°Ý¸Ó¦p¦ó§ï¼g³o­Ó¨ç¼Æ¡B©Î¬O¨Ï¥Î¤£¦P¨ç¼ÆÅýµ²ªGÅܦ¨
¡u¦pªG¥I´Ú¤è¦¡¬°"¤ëµ²¡i©Î¡j"¶×´Ú"®É ¡A«h¥N¦¬´ÚÅã¥Ü¬°0¡v
¦A³Â·Ð¦U¦ì¤j¤j«ü±Ð¤F ÁÂÁÂ!
¦C¦L¦«¹B³æ.rar (386.47 KB)

¦^´_ 1# ciara76190
G2=IF(OR(VLOOKUP(A6,´£³æ©ú²Ó!$B$3:$S$968,10,FALSE)={"¤ëµ²","¶×´Ú"}),0,VLOOKUP(A6,´£³æ©ú²Ó!$B$3:$S$968,10,FALSE))

¤U©Ô

TOP

¦^´_ 2# aer



«D±`ÁÂÁ±zªº¦^ÂÐ
­ì¨Ó¬O§Úªº"OR"¨ç¼Æ¨S¦³¥Î¦b¥¿½T¦ì¸m
¥t¥~·Q­n½Ð±Ð±z ¦b¨ç¼Æ¤¤ {"¤ëµ²","¶×´Ú"}
¦¹³B¨Ï¥Î { } ªº­ì¦]¬O¤°»ò©O?

TOP

¦^´_ 3# ciara76190

¦³Ãö¤½¦¡¨½ªº¤j¬A¸¹§t¸q¥i¥H°Ñ¦Ò¤U¦Cºô§}¤§»¡©ú¡G
https://read01.com/dKjo47.html

TOP

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD