以下是我的运算式;
P6*LOOKUP(I6,{"Y/C/Z","Y/Z/C","C/Z/Y","C/Z","Z/C/Y","S2/S4","Z/C","Z",FALSE},{0.0165,0.033,0.033,0.05,0.066,0.075,0.1,0.15})
都是一些代码,没有大小或是升降问题,但是,结果出来就是有问题,是否不适用lookup这个指令??求高手赐教~~
B1中输入
=IF(A1=CHAR(CODE(A1)),C1*(CODE(A1)-64))
公式旁喊
lookup_vector 中的值必须以升序排列：...,-2, -1, 0, 1, 2, ..., A-Z, FALSE, TRUE。否则，LOOKUP 可能无法返回正确的值。大写文本和小写文本是等同的。
{"Y/C/Z","Y/Z/C","C/桐启锋Z/Y","C/Z","Z/C/Y","S2/S4","Z/C","Z",FALSE}必须排序。局晌
假如反过来，根据数值区间来返回代码，正好。
现在的情况要用弊迟vlookup，
=p6*vlookup(i6,{"Y/C/Z",0.0165;"蚂卜谈Y/Z/C",0.033;"C/Z/Y",0.033;"闷碰C/Z",0.05;"Z/C/Y",0.066;"S2/S4",0.075;"Z/C",0.1;"Z",0.15},2,)
还说你的公式排序了根租腔本没排序，排序是按第二弊州衫参数按升序排序的
=P9*LOOKUP(I9,{"C/Z";"C/Z/Y";"迹带S2/S4";"Y/C/Z";"Y/Z/C";"Z";"Z/C";"Z/C/Y"},{0.05;0.033;0.075;0.0165;0.033;0.15;0.1;0.066})