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

¸Ó¥ÎVLOOKÁÙ¬OCOUNTIF??

¬Û¹ïÀ³ªº°ÝÃD¡A¸Ó¥ÎVLOOK¶Ü?COUNTIF¶Ü?

¦p¹Ï~~¸Ó¦p¦ó·í¦b¥ªÃä¿é¤J¥¿¯Z±¡ªp¤U¡A
                                   ¥kÃ䪽¦¡ªí®æ¨º¥¿¯Z«á­±¥iÅã¥Ü·í¯Z¦W©O?
³Â·Ð¦U¦ì¤j¤j½Ð½ç±Ð~~
¸U¤V°ª¼Ó¥­¦a°_

TOP

¸Ó¥ÎVLOOKÁÙ¬OCOUNTIF??

[attach]18825[/attach]

½Ð°Ý¤@¤U¡A¸Ó¦p¦ó¦b¥ªÃä¾î¦¡±Æ¯Zªí¿é¤J¥¿¯Z°Æ¯Z±¡ªp¤U¡A
¦b¥kÃ䪽¦¡¥¿¯Z°Æ¯Z·Q¹ïÀ³¯Z¦¸¤U·|¦Û°ÊÅã¥Ü¤H¦W?
³Â·Ð¦U¦ì¤j¤j¤F!!@@"
¸U¤V°ª¼Ó¥­¦a°_

¹ï¤£°_¡A¸É­ÓÀÉ®×

±Æ¯Zªí.rar (2.43 KB)

¸U¤V°ª¼Ó¥­¦a°_

TOP

¦^´_ 1# inhogold


§Aªº¹Ï­ù?

TOP

¦^´_ 2# inhogold
§¹¦¨¦pªþ¥ó¡A¦b¥ªÃäªí®æ¿é¤J"¥¿¯Z¡B°Æ¯Z¡B±ß¯Z¡B¦­¯Z"¡A¥kÃäªí®æ·|¥X²{¬Û¹ïÀ³ªº¤H¦W~
±Æ¯Zªí.rar (4.19 KB)

TOP

¦]¬°¤£¯à¸üÀÉ®× ¥u¯àµ¹±z±N´N¬Ý

¥ÎVLOOKUP(A,B,C) OR HLOOKUP(A,B,C)

A=C3Àx¦s®æ,µ¹¿é¤JªÌ¿é¤Jªº¸ê®Æ

B=¿ï¨ú¸ê®Æ®w½d³ò

C=·í´M§ä¨ìA­È,­n¦^¶Ç¸ê®Æ®w¤¤A­È
±o¥ªÃä²Ä´X­Ó¦ì¤l
©Î
A­È¤U¤è²Ä´Xªº¦ì¤l
=VLOOKUP(A1,Z1:ZA20,3)

·N«ä¬O»¡
¤ô¥­´M§ä Z1¨ìZ30 ¤¤A1¤§­È
·í§ä¨ì«á ¦^¶Ç¥ªÃä²Ä¤@­ÓÄ欰¤½¦¡¦p¤U=VLOOKUP(A1,Z1:ZA20,2)
·í§ä¨ì«á ¦^¶Ç¥ªÃä²Ä¤G­ÓÄ欰¤½¦¡¦p¤U=VLOOKUP(A1,Z1:ZA20,3)
§Æ±æ§AÀ´
Cyssuc

TOP

¹ï¤£°_ tku0216¤j,§Ú¤£¦æ¤U¸ü³á!!
§ÚÁÙ¬O¤p¹à¹à @@" sorry
¸U¤V°ª¼Ó¥­¦a°_

TOP

Cyssuc §Aªº§Ú¤£¬O«ÜÀ´,¥i¥H¥Î¹Ï¥Ü¶Ü?
·s¤â....½Ð¦h¥]²[!! ·P®¦!!
¸U¤V°ª¼Ó¥­¦a°_

TOP

¦^´_ 3# inhogold

H1¤½¦¡
=INDEX($A$2:$A$5,MATCH(G1,INDEX($B$2:$D$5,,MATCH(OFFSET(F1,-MOD(ROW()-1,4),),$B$1:$D$1,0)),0),)
¦V¤U½Æ»s
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 8# inhogold

¤U¹Ï¨Ñ°Ñ¦Ò¡A¶È±N´å¼Ð¿ï¦bH1Àx¦s®æ¡AÅã¥Ü8/1ªº¤½¦¡¡A8/2»P8/3¥i¦Û¤v¸Õ¸Õ~
ans.jpg
2014-8-6 14:43

TOP

        ÀR«ä¦Û¦b : ¸Ü¦h¤£¦p¸Ü¤Ö¡A¸Ü¤Ö¤£¦p¸Ü¦n¡C
ªð¦^¦Cªí ¤W¤@¥DÃD