求助求助！怎么把表2的价格自动匹配到表1

sum错位求和，最好能发下文件

=SUM(IFERROR(('C:\Users\0\Desktop\07-08\[表2_20250708_170648.xlsx]Sheet1'!$A$2:$A$20=$A2)*('C:\Users\0\Desktop\07-08\[表2_20250708_170648.xlsx]Sheet1'!$B$2:$B$20=$B2)*('C:\Users\0\Desktop\07-08\[表2_20250708_170648.xlsx]Sheet1'!$D$2:$H$20=C$1)*'C:\Users\0\Desktop\07-08\[表2_20250708_170648.xlsx]Sheet1'!$C$2:$G$20,))表二的地址自己改下

=LET(a,FILTER([表2_20250708_170648.xlsx]Sheet1!$A$2:$H$20,[表2_20250708_170648.xlsx]Sheet1!$A$2:$A$20=$A2),IFERROR(INDEX(a,,MATCH(C$1,a,)-1),""))
右拉下拉！