excel表中如何用函数实现多重条件查找并返回指定值答:依照你举例的单元格位置,复制下面的公式到Sheet2!C1 =INDEX(Sheet1!E$1:E$5,MAX(IFERROR(MATCH(A1&B1,Sheet1!A$1:A$5&Sheet1!B$1:B$5,0),-1),IFERROR(MATCH(A1&B1,Sheet1!A$1:A$5&Sheet1!C$1:C$5,0),-1),IFERROR(MATCH(A1&B1,Sheet1!A$1:A$5&Sheet1!D$1:D$5,...