=VLOOKUP(F9,{0,1220,1410;5,1310,1510;9,1400,1610},IF(E9="经理",3,2),1)
这个是经理与副经理的 如果还有主管 职员 如何添加?
=VLOOKUP(H8{0,870,900,1050,1220,1410,1680;5,870,970,1130,1310,1510,1790;9,870,1040,1210,1400,1610,1900},LOOKUP(F8,{"职员","业务主管","部门主管","副经理","经理","总经理"},{2,3,4,5,6,7}),1)
现在改成这样了 执行数据总是错误
=VLOOKUP(H8{0,870,900,1050,1220,1410,1680;5,870,970,1130,1310,1510,1790;9,870,1040,1210,1400,1610,1900},LOOKUP(F8,{"职员","业务主管","部门主管","副经理","经理","总经理"},{2,3,4,5,6,7}),1)改成这样 执行不了……
追答=VLOOKUP(H8,{0,870,900,1050,1220,1410,1680;5,870,970,1130,1310,1510,1790;9,870,1040,1210,1400,1610,1900},LOOKUP(F10,{"部门主管","副经理","经理","业务主管","职员","总经理"},{4,5,6,3,2,7}),1)
H8后面别忘了逗号,职称和对应的数字要注意在公式中的位置