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

[µo°Ý] ¦p¦ó°w¹ïvlookup¥Î¨â±ø¥ó°µ°Ñ·Ó?

[µo°Ý] ¦p¦ó°w¹ïvlookup¥Î¨â±ø¥ó°µ°Ñ·Ó?

¦p¦ó°w¹ïvlookup¥Î¨â±ø¥ó°µ°Ñ·Ó?
£«·z

¦^´_ 1# meet0718

C2=INDEX($G$1:$G$22,MATCH(A2&B2,$E$1:$E$22&$F$1:$F$22,0),1)    °}¦C¤½¦¡

TOP

¥»©«³Ì«á¥Ñ renzhi2020 ©ó 2012-2-25 23:23 ½s¿è

¦^´_ 2# register313

¥H«e Hsieh sir ±Ðªº
=IF(ISERROR(LOOKUP(2,1/((E2:E22=A2)*(F2:F22=B2)))),0,LOOKUP(2,1/((E2:E22=A2)*(F2:F22=B2)),(G2:G22)))

3.jpg (106.09 KB)

3.jpg

lookup.rar (1.97 KB)

50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

§Ú¨Ó¸Õ¸Õ¬Ý¡A¬Ý¶]¥X¨Óµ²ªG¦p¦ó!ÁÂÁÂ!
£«·z

TOP

¯uªº¦³¸Ñ¨M§Úªº°ÝÃD¤F¡A°ÝÃD§xÂZ¤F§Ú¦n¤[¡A¹ï¨â¦ì¯u¬O·P¿E¤£ºÉ!
£«·z

TOP

¦^´_ 3# renzhi2020


    C2  ­Y=IF(ISERROR(LOOKUP(2,1/((E2:E22=A2)*(F2:F22=B2)))),0,LOOKUP(2,1/((E2:E22=A2)*(F2:F22=B2)),(G2:G22)))

­n½Æ»s®É¦n¹³´N¦³°ÝÃD

¬O§_À³¥[¤W$  C2=IF(ISERROR(LOOKUP(2,1/((E$2:E$22=A2)*(F$2:F$22=B2)))),0,LOOKUP(2,1/((E$2:E$22=A2)*(F$2:F$22=B2)),(G$2:G$22)))

½Æ»s®É¸û¤è«K

TOP

¦^´_ 6# jimmuLu

¨S¿ù
¥Î¨ì¹ï·ÓªíE2:G22ªº¦a¤è,¨ä¦C¦ì§}³£­n¥Îµ´¹ï($)
¤£µM©¹¤U½Æ»s¤½¦¡®É,¨ä¹ïÀ³ªº¹ï·Óªí·|³v¦C©¹¤U²¾

TOP

¬O§_¤]¥i¥H¥ÎSUMPRODUCT ©O  ¦p¤U¡G

TOP

¦^´_ 8# at58441215

C2=SUMPRODUCT(($E$2:$E$22=A2)*($F$2:$F$22=B2)*($G$2:$G$22))

TOP

DEAR REGISTER ¤j¤j
¬Oªº§Ú¬O¥Î³o¼Ëªº¤½¦¡¦^ÂЪº
¤@¯ë§@¦h±ø¥ó¦¡¿z¿ï §Ú³£¥u·|¥Îsumproduct  ¤ñ¸û¤£ª¾¹D¦p¦ó¨Ï¥ÎINDEX©ÎIF(ISERROR(LOOKUP ...) ½Ð°Ý³o´XºØ®t­þ¸Ì ­þºØ¤è¦¡¤ñ¸û¦n¨Ï¥Î©O?

TOP

        ÀR«ä¦Û¦b : §Ñ¥\¤£§Ñ¹L¡A§Ñ«è¤£§Ñ®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD