如果只是"大神"对应"威武",那公式很简单就如大家所写的=IF(A1="大神","威武","")如果对应的内容有多个,如还有"天神"对"无敌","小神"对"神威","金刚"对"怒威"则公式应写成=IF(A1="","",VLOOKUP(A1,{"天神","无敌";"大神","威武";"小神","神威";"金刚","怒威"},2,))这样用VLOOKUP就可以对应A1可能出现多个不同的内容返回各自对应的值如果数据对应是大量的建议建立一个对应的数据表格http://office.microsoft.com/zh-cn/excel-help/RZ101862716.aspx?section=3...
|