求大佬帮忙，想在价格表中查询对应日期的物料价格

=TAKE(FILTER(C2:C6,(A2:A6&B2:B6=G2&H2)*(E2:E6<=I2)),-1)

=TAKE(FILTER(C2:C6,(A2:A6=G2)*(B2:B6=H2)*(E2:E6<I2)),-1)

=LET(x,FILTER($C$2:$E$6,($A$2:$A$6=G2)*($B$2:$B$6=H2)),XLOOKUP(I2,TAKE(x,,-1),TAKE(x,,1),,-1))

=@SORT(FILTER($C$2:$E$6,($A$2:$A$6=G2)*($B$2:$B$6=H2)*($E$2:$E$6<=I2)),3,-1)

Sub 案例12()
'确认A1区域行数
a1 = [a1].CurrentRegion.Rows.Count
For I = 2 To a1
Debug.Print Cells(I, 1).Value
If Cells(I, 1).Value = [H2].Value Then
Debug.Print "品名相等"
If Cells(I, 5).Value < [J2].Value Then
[K2].Value = Cells(I, 3).Value
End If
End If
Next I
End Sub