=lookup(A2,{0,3.000001,6.000001,10.000001,15.000001,20.000001,25.000001},{1,2,3,4,5,6,7})
公式=IFERROR(LOOKUP(1,0/(A1>{0,3,6,10,15,20,25}),ROW($1:$7)),0)
把条件改成竖排的用vlookup模糊查询
=A2*hlookup(B2,A3:J4,2,1)
