满足多条件提取数据,请大神帮忙
根据月份,项目。地名从表2中提取相应的数据。如1月,收入类,北京从表2中提取数据到表1B3=IFERROR(INDEX(Sheet2!$C$2:$G$16,MATCH($A$1&$A3,Sheet2!$B$2:$B$16&Sheet2!$A$2:$A$16,),MATCH(B$2,Sheet2!$C$1:$G$1,)),"")
数组三键,下拉、右拉。 =SUMPRODUCT((Sheet2!$A$2:$A$16=$A3)*(Sheet2!$C$1:$G$1=B$2)*(Sheet2!$B$2:$B$16=$A$1)*(Sheet2!$C$2:$G$16)) 十分感谢,可以了
页:
[1]