excel如何根据两个条件确定一个数值?答:这样的?=VLOOKUP(G2&H2,IF({1,0},A:A&B:B,C:C),2,FALSE)数组公式,ctrl+shift+回车确认。如果你的excel支持xlookup =XLOOKUP(G2&H2,A:A&B:B,C:C,,0)
EXCEL表格满足两个条件时,返回一个指定结果的函数或数组怎样完成?_百度...答:=INDEX($F$3:$J$8,MATCH(B6,$G$3:$G$8,0),IF(C8="高山站",3,IF(C6="低山站",4,5)))或者:=INDEX($F$3:$J$8,MATCH(B6,$G$3:$G$8,0),MATCH(C6,$F$2:$J$2,0))