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

[µo°Ý] INDEX AND MATCH

[µo°Ý] INDEX AND MATCH

¥»©«³Ì«á¥Ñ mdr0465 ©ó 2017-4-15 21:52 ½s¿è

¦U¦ì¤j¤j:

  §Ú·Q±Nbreakdown ªº¸ê®Æ¥Îmatch and index ¦b¥t¤@¤À­¶ P & Q  Äæ½ü¤J´N¥i¥H¦bD4®æ¤º¦Û°Ê¥X²{,½Ð°Ýªº¿ù¤°»ò©O?



pic1.PNG (62.68 KB)

pic1

pic1.PNG

3¤ë?¥ó¤u¤H?©ú?ªí.rar (63.16 KB)

D4

{=INDEX(BREAKDOWN!$F$2F$659,MATCH(P4&Q4,BREAKDOWN!$A$2A$659&BREAKDOWN!$E$2E$659,))}
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : §ïÅܦۤv¬O¦Û±Ï¡A¼vÅT§O¤H¬O±Ï¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD