如何从excel某列中筛选出包含另外一列关键词的行?答:我来一个通用版本的公式 =IFERROR(INDEX($C$1:$C$400,SMALL(IF(COUNTIF(A2,"*"&$C$2:$C$400&"*"),ROW($2:$400),""),1)),"")&""CTRL+SHIFT+回车,再向下填充 或是 =IFERROR(INDEX($C$1:$C$400,SMALL(IF(ISNUMBER(FIND($C$2:$C$400,A2)),ROW($2:$400),""),1))...
excel如何通过两个关键字从数据档案库中提取数据?答:sheet1 sheet2 C2=VLOOKUP(A2&B2,IF({1,0},Sheet1!A:A&Sheet1!D:D,Sheet1!B:B),2,0)D2=VLOOKUP(A2&B2,IF({1,0},Sheet1!A:A&Sheet1!D:D,Sheet1!C:C),2,0)数组公式,ctrl+shift+回车确认。如果EXCEL是支持XLOOKUP的版本,SHEET2 C2=XLOOKUP(A2&B2,Sheet1!A:A&Sheet1!D:...