用IF公式太长,运行不了
求助更好的公式,
=IF(T124=1,"蛇猴",IF(T124=2,"龙羊狗",IF(T124=3,"兔马鸡鼠",IF(T124=4,"虎蛇猴猪",IF(T124=5,"牛龙羊狗",IF(T124=6,"鼠兔马鸡",IF(T124=7,"虎蛇猴猪",IF(T124=8,"狗牛龙羊",IF(T124=9,"鸡鼠兔马",IF(T124=10,"猪虎蛇猴",IF(T124=11,"牛龙羊",IF(T124=12,"兔马","蛇"))))))))))))
因为从1-24分别对应不同的字符串所以,你可以把对应表放到另一个工作表中,如下图所示:
我图中用ABCD等代表你的各个属象字符串,然后你就可以这样用了,见公式:
=VLOOKUP(A2,Sheet2!A$1:B$9,2)
示例见图: