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

½Ð±Ð«ö¨â­Ó±ø¥ó³£²Å¦X§ä¨ì·j´M­Èªº¨ç¼Æ¼gªk

=IF(COUNTIF($A$2A$18,$F3),IF(COUNTIF($B$2B$18,$G3),LOOKUP(1,1/($A$2A$18&$B$2B$18=$F3&$G3),$C ...
fr447446 µoªí©ó 2011-3-29 09:05



­º¥ý·PÁ±zªº«ü¾É
¨Ì±zªº´£¨Ñ¤w¸g¥i¥H¹F¨ì§Ú»Ý¨D

¹ï©ó¬Ý¤£À´°Q½×°Ï¬Û¦ü¥DÃDªº»¡©ú¤]ı±o«Ü²Û·\
¹ê¦b¬O¤u§@»Ý­n¨S¦³«Ü¦h®É¶¡Åý§ÚºCºCÁA¸Ñ
¤~µwµÛÀY¥Ö°Ý

¹ï©ó°}¦CªºÆ[©À¤£¬O«ÜÀ´
¥i§_¦A½Ð±Ð¤@¤U¨ç¼Æ¤¤
=LOOKUP(1,1/($A$2:$A$18&$B$2:$B$18=$F2&$G2),$C$2:$C$18)
²Ä¤@­Ó¤Þ¼Æ1¬O«ü?
²Ä¤G­Ó¤Þ¼Æªº·N«ä¬O?

¤£½×¦p¦ó¯uªº«ÜÁÂÁ±zÄ@·N¬°§Ú¸Ñ¨M¤§«eªº°ÝÃD

ÁÂÁÂ
Ann

TOP

«Øij§A¦h§ä§ä¡A¦h¬Ý¬Ý¡A§â½×³õªº©«¤l³£¬Ý§¹¤F¡A¦¨¤£¤F¥P¤]¦¨¦ò¤F¡Ichin15 µoªí©ó 2011-3-29 08:23



½T¹ê...§Ú¤§«eÁÙ¨Sµo²{³o­Óºô¯¸¤§«e¤]¬O¤@ª¾¥b¸Ñ¡A

¬Ý¤F¤@¬q®É¶¡¤§«áÁöµM¤´¬O¥b±í¤ô¡A¦ý»{ÃѪº¤u¨ã¤w¸g°÷¹B¥Î¦b¥Ø«eªº¤u§@¤W¤F~
¨S¨Æ´N¨Ó³}³}

TOP

=IF(COUNTIF($A$2:$A$18,$F3),IF(COUNTIF($B$2:$B$18,$G3),LOOKUP(1,1/($A$2:$A$18&$B$2:$B$18=$F3&$G3),$C$2:$C$18),"µL¸Ó¶µª÷ÃB"),"µL¶Ç²¼¸ê®Æ")

IF¥Îªk.jpg (81.13 KB)

IF¥Îªk.jpg

¨S¨Æ´N¨Ó³}³}

TOP

§Ú¬Ý¨ì«Ü¦h¬Û¦Pªº¨Ò¤l¡A´N¦b³o­Ó°Q½×ª©
¦P¾Ç­Ì¦h¥b¥Îlookup¨ç¼Æ©Îsumproduct¨ç¼Æ³B²z³oÃþ°ÝÃD
«Øij§A¦h§ä§ä¡A¦h¬Ý¬Ý¡A§â½×³õªº©«¤l³£¬Ý§¹¤F¡A¦¨¤£¤F¥P¤]¦¨¦ò¤F¡I

TOP

        ÀR«ä¦Û¦b : ¥¬¬I¦p¼½ºØ¡A¥HÅw³ß¤ß´þ¼íºØ¤l¡A¤~·|µoªÞ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD