如果Sheet2中单价在D列，那么在Sheet1输入以下公式，然后向下填充公式=LOOKUP(1,0/((Sheet2!B$2:B$200=B2)*(Sheet2!C$2:C$200=C2)),Sheet2!D$2:D$200)
