ªð¦^¦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?



pic 1

pic2.PNG
2017-4-15 21:46

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 : ¤Ó¶§¥ú¤j¡B¤÷¥À®¦¤j¡B§g¤l¶q¤j¡A¤p¤H®ð¤j¡C
ªð¦^¦Cªí ¤W¤@¥DÃD