Excel大神们,求教怎么行列多条件匹配数据?答:在C11输入以下公式,然后向下填充公式 =INDEX(OFFSET(B$4:E$8,,VLOOKUP(LEFT(C11,2),{"河南",0;"河北",4;"山东",8},2,0)),MATCH(B11,A$4:A$8,0),MATCH(RIGHT(C11,LEN(C11)-2),$B$3:$E$3,0))详见附图示例
Excel满足多个条件,如何匹配对应单元格答:=IF(OR($C6="",$E6=""),"",VLOOKUP($E6,$W$6:$AA$12,IF($C6=$X$5,3,5),0)),很简单,我想你能理解,不用解析吧。如果要屏蔽C,E列错误输入(比如C列输入C类岗,E列输入8级)而出现的错误,则:=IFNA(IF(OR(AND($C6<>$X$5,$C6<>$Z$5),$E6=""),"C、E列为空或C...