假设你这个表格在sheet1，另一个表在sheet2，客户名在A列，规格在B列在C1输入 =INDEX(Sheet1!$B$2:$G$5,MATCH(Sheet2!A1,Sheet1!$A$2:$A$5,0),MATCH(Sheet2!B1,Sheet1!$B$1:$G$1,0))然后下拉应该可以
