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

¤@¹ï¦hªº¬d¸ß

¤@¹ï¦hªº¬d¸ß

½Ð°Ý­n±q¤@¦ê¸ê®Æ¤º¬d¸ß¨ì¹ïÀ³ªº¸ê®Æ, À³¸Ó­n«ç»ò°µ©O?
ÁÂÁÂ~

AAAA.jpg (25.37 KB)

AAAA.jpg

Sorry, §Úªþ¤WÀÉ®×


Book -1.rar (33.61 KB)

TOP

=IFERROR(LOOKUP(,0/(($C2=$C$14:$C$20)*(D$1=$D$14:$D$20)),$E$14:$E$20),"")
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

ÁÂÁÂ~
¤£¹L¤U¤è¶À¦âÀx¦s®æ¦¡¤£À³¸Ó¦³¼Æ­Èªº, ­n¦p¦ó­×§ï©O?

BOOK-1.jpg

TOP

¦^´_ 4# samlin0403
¦]¬°¤½¦¡¸Ìªº§PÂ_³£¬O±q $C$14:$C$20 °Ï¬q¶}©l§ä°_¤§¬G¡C

TOP

http://blog.xuite.net/hcm19522/twblog/363786872

TOP

M¤j, §ÚÁÙ¦³¤@­Ó¤p°ÝÃD,
¦pªG¦r¦ê¤£¤@©w­n§¹¦¨¬Û²Å, ¥u­n²Å¦X¨ä¤¤ªº¨â­Ó¦r,«K±a¤J¤é´Á.
¨º¥H¤Uªº¨ç¼Æ¸Ó¦p¦ó­×§ï©O?


=IFERROR(LOOKUP(,0/(($C2=$C$14:$C$20)*(D$1=$D$14:$D$20)),$E$14:$E$20),"")

TOP

M¤j, §ÚÁÙ¦³¤@­Ó¤p°ÝÃD,
¦pªG¦r¦ê¤£¤@©w­n§¹¦¨¬Û²Å, ¥u­n²Å¦X¨ä¤¤ªº¨â­Ó¦r,«K±a¤J¤é´Á.
¨º¥H¤Uªº¨ç¼Æ¸Ó¦p ...
samlin0403 µoªí©ó 2015-12-11 00:13



§A­n¦b3¼Ó¤U¤èªº«ö¦^ÂСA¨t²Î¤~·|³qª¾¸Ó¤H­û¡A¤£µM§Ú¤]¤£ª¾¹D¦³µoªí·s°ÝÃD

    =IFERROR(LOOKUP(,0/(($C2=$C$14:$C$20)*(D$1=$D$14:$D$20)),$E$14:$E$20),"")

­Y¬O §½³¡¦r ¬d¸ß¡A¤@¯ë¬O¥ÎFIND¨ç¼Æ
($C2=$C$14:$C$20) => ISERROR(FIND($C2, $C$14:$C$20))-1
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ºw¤ô¦¨ªe¡C²É¦Ì¦¨ÅÚ¡A¤Å»´¤vÆF¡A¤Å¥Hµ½¤p¦Ó¤£¬°¡C
ªð¦^¦Cªí ¤W¤@¥DÃD