- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
|
¥»©«³Ì«á¥Ñ ML089 ©ó 2014-7-23 22:34 ½s¿è
¦^´_ 6# p212
>>¥i§_·Ð½ÐML089ª©¥D½ç±Ð¡H
>>1¡BL2 =OFFSET($A$1,0,MATCH(30,B2:K2,))
>>(1)¨ämatch_type¡u¬Ù²¤¡v©M¿é¤J¡u1¡v¬O¤@¼Ëªº¡A¦ý¬°¦ó¦b1#ªº½d¨ÒÀÉ·|§e²{¡N/A¡H
>>(2)±z¹ïmatch_type¬°¦ó¤£¥Î¡u0¡v¡H¡]1#¤£¬O¥ÎMATCH«ü©w´M§ä¡u30¡v¡^
¦^ÂÐ:
(1)
¦pªG match_type ¬O 1¡A«h MATCH ¨ç¼Æ·|§ä¨ìµ¥©ó©Î¶È¦¸©ó lookup_value ªºÈ¡CLookup_array ¥²¶·¥H»¼¼W¦¸§Ç±Æ¦C¡G...-2, -1, 0, 1, 2, ..., A-Z, FALSE, TRUE¡C
줽¦¡¤¤¦]Lookup_array¨S¦³»¼¼W¦¸§Ç±Æ¦C©Ò¥H¿ù»~
(2)
=OFFSET($A$1,0,MATCH(30,B2:K2)) ³o¼Ëmatch_type¬O¬Ù²¤¬° 1
=OFFSET($A$1,0,MATCH(30,B2:K2,))³o¼Ëmatch_type¬On¿é¤J¨S¦³¿é¤J¬° 0 (³o¬O²¤Æ¿é¤JªºÃa²ßºD¡A½Ð¨£½Ì)
>>2¡BL22 =LOOKUP(,0/(B22:K22=30),$B$1:$K$1)
>>(1)¨älookup_value¬°¦ó¥i¬Ù²¤¡H¬Ù²¤ªºÈªí¥Ü¬°¡u0¡v¡H
>>(2)¦b¦¹LOOKUP±o¨ìªº°}¦C¬O¤°»ò¡H
¦^ÂÐ:
(1)
L22 =LOOKUP(,0/(B22:K22=30),$B$1:$K$1)
lookup_value¨Ã¨S¦³¬Ù²¤¥u¬On¿é¤J¨S¦³¿é¤J®É¬° 0 (³o¬O²¤Æ¿é¤JªºÃa²ßºD¡A½Ð¨£½Ì)
(2)
B34:K34 = {100,100,30,100,100,100,100,100,100,100}
0/(B34:K34=30) = {#DIV/0!,#DIV/0!,0,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!}
L34 =LOOKUP(,0/(B34:K34=30),$B$1:$K$1) = 3
LOOKUP¨ã¦³®e¿ù¯à¤O¡AÁöµM Lookup_vector¤¤¦³#DIV/0!¿ù»~¸ê®Æ®É¨Ã¤£·|¤¤Â_¤´·|Ä~Äò¶i¦æ§@·~¡A²Å¦X®É 0/TRUE = 0¡Alookup_value ¥Î 0¥i§ä²Å¦X±ø¥ó¥ô¤@µ§(¤@¯ë¥Î©ó°ß¤@²Å¦X±ø¥ó)¡A¥Î 1¥i§ä²Å¦X±ø¥ó³Ì«á¤@µ§¡C |
|