- ©«¤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-11
|
©w¸q¦WºÙ:
X:=--SUBSTITUTE(LEFT(±±ªí!A2,LEN(±±ªí!A2)-1),"3A",4)
Y:'="B"&SUM(N(±±ªí!X<={0,12,25,39,999}))&"F/"&±±ªí!X
C2:
=LOOKUP("z",CHOOSE({1,2,3},"",VLOOKUP(Y,¦¨¥æ©ú²Ó!$E:$J,6,),VLOOKUP(Y,¦¨¥æ©ú²Ó!$G:$J,4,)))
©Î
=IFERROR(IFERROR(VLOOKUP(Y,¦¨¥æ©ú²Ó!$E:$J,6,),VLOOKUP(Y,¦¨¥æ©ú²Ó!$G:$J,4,)),"") |
|