- ©«¤l
- 2833
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 2889
- ÂI¦W
- 0
- §@·~¨t²Î
- ¡e²¤¡f
- ³nÅ骩¥»
- ¡e²¤¡f
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¡e²¤¡f
- µù¥U®É¶¡
- 2013-5-13
- ³Ì«áµn¿ý
- 2024-11-12
|
X©w¸q¦WºÙ§ï:
=VALUE(SUBSTITUTE(LEFT(±±ªí!A2,LEN(±±ªí!A2)-1),"3A",4))
C2¤½¦¡:
=LOOKUP("z",IF({1,0},"",VLOOKUP("B"&MATCH(-X,-{999,39,25,12})&"F/"&X,¦¨¥æ©ú²Ó!$E$2:$J$49,6,)&""))
©Î
=LOOKUP("z",IF({1,0},"",VLOOKUP("B"&5-MATCH(X,{0,13,26,40})&"F/"&X,¦¨¥æ©ú²Ó!$E$2:$J$49,6,)&"")) |
|