Question

excel 表格公式老是出错，请大神来指导

=LOOKUP(M5&N5,{"滞后较差","滞后一般","滞后良好","滞后优秀","滞后卓越","准时较差","准时一般","准时良好","准时优秀","准时卓越";"0.48","0.60","0.72","0.84","0.96","0.64","0.76","0.88","1","1.12"})

滞后良好始终是指向0.48，准时一般始终指向0.88，其他的都是对的。请大家帮忙看看。

Answer 1

公式改为：
=LOOKUP(M5&N5,{"滞后较差","滞后良好","滞后一般","滞后优秀","滞后卓越","准时较差","准时良好","准时一般","准时优秀","准时卓越";0.48,0.72,0.6,0.84,0.96,0.64,0.88,0.76,1,1.12})

出错原因，数据列表没有按升序排列。

公式也可以改为：
=LOOKUP(1,0/(M5&N5={"滞后较差","滞后一般","滞后良好","滞后优秀","滞后卓越","准时较差","准时一般","准时良好","准时优秀","准时卓越"}),{0.48,0.60,0.72,0.84,0.96,0.64,0.76,0.88,1,1.12})

（这个公式，可以不用排序。另外，如果要得出数值结果，公式中数字不用加引号。）