Question

excel如何根据月份和日期判定星座？

如图，如何根据Z、AA的月份和日期计算出AC的星座？

Answer 1

参考：疑难188 如何根据出生日期得到星座
=LOOKUP(Z2&AA2,{101,"摩羯座";120,"水瓶座";219,"双鱼座";321,"白羊座";420,"金牛座";521,"双子座";621,"巨蟹座";723,"狮子座";823,"处女座";923,"天秤座";1023,"天蝎座";1122,"射手座";1222,"摩羯座"})

追问

不可用，直接合并根本无法计算

追答

没注意图片日期的格式，改为：
=LOOKUP(Z2*100+AA2,{101,"摩羯座";120,"水瓶座";219,"双鱼座";321,"白羊座";420,"金牛座";521,"双子座";621,"巨蟹座";723,"狮子座";823,"处女座";923,"天秤座";1023,"天蝎座";1122,"射手座";1222,"摩羯座"})

Answer 2

=VLOOKUP(--(Z2&AA2),{101,"魔羯";121,"水瓶";220,"双鱼";321,"白羊";421,"金牛";522,"双子";622,"巨蟹";723,"狮子";824,"处女";924,"天秤";1024,"天蝎";1123,"射手";1222,"魔羯"},2)