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

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

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

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
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 8# clio

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

OR


   INDEX(D:D,MATCH(,0/(B$1:B3=B4),))
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

        ÀR«ä¦Û¦b : ¤Ó¶§¥ú¤j¡B¤÷¥À®¦¤j¡B§g¤l¶q¤j¡A¤p¤H®ð¤j¡C
ªð¦^¦Cªí ¤W¤@¥DÃD