Hi everyone,

I've got the following formula:
{=SUM(Table1[Volume]*VLOOKUP(Table1[Date],CTR!$B$3:$C$103,2,FALSE))}
Unfortunately it is not working as I expected, since the VLOOKUP will always return the VLOOKUP value of the first Table1[Date] value.

Is there a way to make it so the Table 1[Date] value follows the table as I would expect?

Thanks!