IF(OR(ISNUMBER(SEARCH({"诸葛孔明";"刘备";"曹操";"关羽";"张飞"},F2))),"三国","")&IF(OR(ISNUMBER(SEARCH({"孔明";"孔亮";"宋江";"李逵";"鲁智深"},F2))),"水浒","")&IF(OR(ISNUMBER(SEARCH({"牛魔王";"孙悟空";"猪八戒";"唐僧"},F2))),"西游","")&IF(OR(ISNUMBER(SEARCH({"贾宝玉";"林黛玉";"薛宝钗"},F2))),"红楼","")&IF(OR(ISNUMBER(SEARCH({"姜子牙";"哪吒";"杨戬";"雷震子"},F2))),"封神","")
PS：需要谁套都可以直接用，尽量不是最新版本的函数

不如做辅助表然后直接vlookup

做个对照表引用