本帖最后由 qqyyh 于 2013-7-23 14:21 编辑
【函中201301班】-C06-qqyyh
1.=VLOOKUP(LOOKUP(9,FIND($D$182:$D$186,G182),$D$182:$D$186),$D$181:$E$186,2,) 下拉
2.=VLOOKUP(SUBSTITUTE(G191,"*","~*"),$D$191:$E$205,2,) 下拉
3.=ROUND(D209/LOOKUP(15,$E$209:E209),5) 下拉
4.=VLOOKUP(E226,$D$218:$J$223,MATCH(E225,D218:J218,0),)
=VLOOKUP(E226,$D$219:$J$223,MATCH(E225,E218:J218,0)+1,)
5.=SUBSTITUTE(-LOOKUP(,-LEFT("1"&D231,ROW($1:$20))),"1","",1) 下拉
=MID(LOOKUP(,-LEFT("1"&D231,ROW($1:$20))),3,18) 下拉
=MID(LOOKUP(,-MID("1"&D231,1,ROW($1:$18))),3,18) 下拉
=LEFT(D231,LOOKUP(9,FIND({"K","M","V"},D231))-1) 下拉
|