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

¿é¤J¬Û¦P½s¸¹®É, ¦Û°ÊÅã¥Ü¤W¤@µ§»ÈÃB

¿é¤J¬Û¦P½s¸¹®É, ¦Û°ÊÅã¥Ü¤W¤@µ§»ÈÃB

Test_NumberAmt.rar (6.29 KB)

=LOOKUP(1,0/(B$2:B3=B4),D$2:D3)

TOP

¦^´_ 2# fengetianxia

  ¦¹¤½¦¡¤£¦æ

  ¦]¬°¸ê®Æ«ùÄò¼W¥[¤¤.

TOP

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 4# hcm19522

   µª®×¥¿½T, ÁÂÁÂ!

TOP

¦^´_ 4# hcm19522
½Ð±Ð¤@¤Uhcm19522¤j¤j¡G
«ôŪ¤Fµ{¦¡¡A¥i¬O¤£¤F¸Ñ0/(B$1:B6=B7)³o­Óªº¨Ï¥Î¤âªk¡A¤£ª¾¹D¯à§_¸Ñ»¡¤@¤U©O¡H·PÁ±z¡C
clio

TOP

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2017-8-29 19:04 ½s¿è

¦^´_ 6# clio
(¤@)¨Ò :LOOKUP(A1,{1,5,9},{"A","B","C"})-->A1=1~4-->"A" ,5~8-->"B" ,9(§t)¥H¤W-->"C"-->¥t¸Ñ 1(§t)¥H¤W¬OA  ;5(§t)¥H¤W¬OB  ;9(§t)¥H¤W¬OC ;<1 ¿ù»~
(¤G)±ø¥ó¦¨¥ß¬°¯u(TURE) ±ø¥ó¤£¦¨¥ß¬°°² (FALSE)-->LOOKUP(1,0/±ø¥ó¬O§_¦¨¥ß,¹ïÀ³¦C)-->0/TURE©ÎFALSE-->0»PµL·N¸q-->LOOKUP§ä¨ì³Ì«á¤@­Ó¬°¯u .¬°0 ªÌ
¨Ò :A1:A5={1,2,3,4,5}-->LOOKUP(1,0/(A1:A5<3),{11,12,13,14,15})-->0/(A1:A5<3)²£¥Í{0,0,µL·N¸q,µL·N¸q,µL·N¸q}-->§ä¨ì³Ì«á¤@­Ó¬°¯u .¬°0 ¬O²Ä¤G¦ì¸mªº¹ïÀ³¦C 12
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 7# hcm19522
·PÁÂHcm19522ªº¸Ô²Ó¸ÑÄÀ¡A³o¼Ë§Ú²M·¡¤F¡ALOOKUP(5,0/(B$1:B3=B4),D$1:D3))¬O§ä¥X³Ì«á¤@µ§¬°¯uªº¸ê®Æ¡A¨º°²¦p­n§ä²Ä¤@µ§©O¡H¥i¥H«ç»ò­×¥¿©O¡H
clio

TOP

¦^´_ 8# clio

INDEX(D$1:D3,MATCH(,0/(B$1:B3=B4),))

OR


   INDEX(D:D,MATCH(,0/(B$1:B3=B4),))
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 9# hcm19522
¤F¸Ñ¡K·PÁÂhcm19522¡A³o¼Ë§Ú´N§¹¥þ¤F¸Ñ¤F¡A·PÁ±z­@¤ßªº¸Ñ»¡
clio

TOP

        ÀR«ä¦Û¦b : ÀR§¤±`®¦¤v¹L¡B¶¢½Í²ö½×¤H«D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD