Question

excel中LOOKUP(B3,{"一","二","三","四","五","六","日"},{"二","三","四","五","六","日","一"})哪错了

为什当b3等于五或一时，返回值是一？当b3等于六或日时，返回值是三。中括号中是纯数字就没事

Answer 1

因为lookup要求第二个参数是递增de数列，而中文的是按拼音排序的，需要换顺序才行

追问

怎么换，没有太明白

追答

=LOOKUP(B3,{"二","六","日","三","四","五","一"},{"三","日","一","四","五","六","二"})