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

¦p¦óÅý­È¥u¨qªÅ¥Õ

¦p¦óÅý­È¥u¨qªÅ¥Õ

³Ò·Ð¦U¦ì¤j¤j¤F
=IF(COUNTIF(­×§ïª©¦¸!$A$3:$A$10000,$B6),(LOOKUP(2,1/(­×§ïª©¦¸!$A$3:$A$10000=$B6),(­×§ïª©¦¸!$E$3:$E$10000))))
³o¼Ëªº¤½¦¡¶Ç¦^FALSE
§ÚÀ³¸Ó«ç»ò¥[¤~·|Åý¥¦¬OªÅ®æ

³Ò·Ð¦U¦ì¤j¤j¤F
=IF(COUNTIF(­×§ïª©¦¸!$A$3A$10000,$B6),(LOOKUP(2,1/(­×§ïª©¦¸!$A$3A$10000=$B6),(­× ...
sheau-lan µoªí©ó 2015-10-6 13:05



   =IF(COUNTIF(­×§ïª©¦¸!$A$3:$A$10000,$B6),LOOKUP(2,1/(­×§ïª©¦¸!$A$3:$A$10000=$B6),(­×§ïª©¦¸!$E$3:$E$10000)),"")

TOP

¦hÁ¤j¤jÀ°¦£
¥i¥H¤F...
·P¿E
­ì¨Ó§Ú³Ì«á­±¦h¤F¤@­Ó¬A©·,©Ò¥H¤@ª½¨S¿ìªk,³£¿ù»~

TOP

¦hÁ¤j¤jÀ°¦£
¥i¥H¤F...
·P¿E
­ì¨Ó§Ú³Ì«á­±¦h¤F¤@­Ó¬A©·,©Ò¥H¤@ª½¨S¿ìªk,³£¿ù»~
sheau-lan µoªí©ó 2015-10-6 15:35



§A­ì¨Ó¬A¸¹¨S¿ù¡A¥u¬O¤Ó¦h²Õ¤F¡A¦³¨Ç¬O¦h¾l¥i§R¡C
­×§ï¤½¦¡®É¥uÀ°§A§R±¼¤@²Õ¡AÀ³¸ÓÁÙ¦³¤@²Õ¥i§R¡C

TOP

¦^´_ 1# sheau-lan

¤èªk£¸
=IF(COUNTIF(­×§ïª©¦¸!$A$3:$A$10000,$B6),LOOKUP(2,1/(­×§ïª©¦¸!$A$3:$A$10000=$B6),­×§ïª©¦¸!$E$3:$E$10000),"")


¤èªk¤G EXCEL V2007ª©¥H¤W
=IFERROR(LOOKUP(2,1/(­×§ïª©¦¸!$A$3:$A$10000=$B6),­×§ïª©¦¸!$E$3:$E$10000),"")
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ±o²z­nÄǤH¡A²zª½­n®ð©M¡C
ªð¦^¦Cªí ¤W¤@¥DÃD