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

[µo°Ý] ¦p¦óÅýIF+ISERROR¤£­n¥X²{0

[µo°Ý] ¦p¦óÅýIF+ISERROR¤£­n¥X²{0

=IF(ISERROR(VLOOKUP(B15,IF({1,0},¤u§@ªí1!$B$15:$B$100,¤u§@ªí1!$A$15:$A$100),2,)),"",VLOOKUP(B15,IF({1,0},¤u§@ªí1!$B$15:$B$100,¤u§@ªí1!$A$15:$A$100),2,))

=IF(B15="","",IF(ISERROR(VLOOKUP(B15,IF({1,0},¤u§@ªí1!$B$15:$B$100,¤u§@ªí1!$A$15:$A$100),2,)),"",VLOOKUP(B15,IF({1,0},¤u§@ªí1!$B$15:$B$100,¤u§@ªí1!$A$15:$A$100),2,)))

TOP

¦^´_ 2# fengetianxia

µª®×ÁÙ¬O·|¥X²{0¡A½Ð¦Ñ®v¸Ô¦pªþ¥ó
¤å¨ã°Ó«~­qÁʳæ - ½Æ»s.rar (25.06 KB)

TOP

[i=s] ¥»©«³Ì«á¥Ñ fengetianxia ©ó 2016-10-14 16:51 ½s¿è [/i]

=IF(OR(ISERROR(VLOOKUP(B15,IF({1,0},¤u§@ªí1!$B$15:$B$100,¤u§@ªí1!$A$15:$A$100),2,)),VLOOKUP(B15,IF({1,0},¤u§@ªí1!$B$15:$B$100,¤u§@ªí1!$A$15:$A$100),2,)=0),"",VLOOKUP(B15,IF({1,0},¤u§@ªí1!$B$15:$B$100,¤u§@ªí1!$A$15:$A$100),2,))

¦pªG­n¤Þ¥Îªº¬O¤å¦rÃþªº¼Æ¾Ú,¥i¥Hª½±µ
=T(IF(ISERROR(VLOOKUP(B15,IF({1,0},¤u§@ªí1!$B$15:$B$100,¤u§@ªí1!$A$15:$A$100),2,)),"",VLOOKUP(B15,IF({1,0},¤u§@ªí1!$B$15:$B$100,¤u§@ªí1!$A$15:$A$100),2,)))

TOP

vlookup()¬d¨ìªºµ²ªG¬OªÅ¥ÕÄæ¦ì´N·|¦^³ø0,¤£·Q¬Ý¨ì0´N¥Î¨ä¥L¨ç¼Æ¡C0¸òiferror()µLÃö¡C¤@¯ëvlookup()¬O¥Îcountif()±Æ°£¿ù»~¡C

TOP

¦^´_ 4# fengetianxia


   ¹ï~§Úªº¬O¤å¦r¡A©Ò¥Hª½±µ¨Ï¥Î¤j¤jªº²Ä¤G­Ó¤è¦¡¡A¦¨¥\¤F¡A¸U¤À·PÁ¡C
¤]«D±`·PÁÂANGELAª©¥Dªº´£¿ô¡C

TOP

        ÀR«ä¦Û¦b : §g¤l¬°¥Ø¼Ð¡A¤p¤H¬°¥Øªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD