在EXCEL中，如何判断A列是否含有B列内容，并返回与B列对应的C列数值？

Question

如题，想直接填B列

Answer 1

您好！不知道是不是下面的样子。在单元格输入：=IF(ISNUMBER(FIND("人民日报",A2)),"SSS",IF(ISNUMBER(FIND("恒大",A2)),"A+",IF(ISNUMBER(FIND("联通",A2)),"SSS",IF(ISNUMBER(FIND("移动",A2)),"A",""))))。

或者输入这个函数：=IFERROR(LOOKUP(1,0/FIND({"人民日报","恒大","联通","移动"},A2),{"SSS","A+","SSS","A"}),"")

Answer 2

=IFERROR(LOOKUP(1,1/SEARCH(E$2:E$5,A2),F$2:F$5),"无数据")

Answer 3

=LOOKUP(1,0/FIND(E$2:E$1000,A2)/(E$2:E$1000<>""),F$2:F$1000)本回答被提问者采纳