1.多条件取最小
值查询代码:
=IF(D6149>=500,MIN(LOOKUP(E6149,{0,1500,2500,6000,10000},{0,17,37,67,97}),LOOKUP(E6149,{0,15000,25000,60000,100000},{0,37,67,97,167}),LOOKUP(E6149,{0,90000,150000,360000,600000},{0,97,167,367,867}),LOOKUP(E6149,{0,300000,500000,1200000,2000000},{0,167,367,867,1367}),LOOKUP(E6149,{0,900000,1500000,3600000,6000000},{0,367,867,1367,3367}),LOOKUP(E6149,{0,3000000,5000000,12000000,20000000},{0,867,1367,3367,8367}),LOOKUP(E6149,{0,9000000,15000000,36000000,60000000},{0,1367,3367,8367,16367}),LOOKUP(E6149,{0,24000000,40000000,96000000,160000000},{0,8367,16367,36367,99367})),"不符合")
2.绝对搜索代码:
=INDEX(B$1:B$12075,MATCH(C1,A$1:A$12075,))
2.绝对搜索代码:
=INDEX(B$1:B$12075,MATCH(C1,A$1:A$12075,))
更多推荐
EXCEL 代码大全
发布评论