I know that a pivot table would be ideal. The problem is that I have
data on the chart(targets, etc) that do not come from the list.

So what I am trying to do is something like a sum of vlookups. If
this cell has this value, add its value from another cell in the same
row to the sum of the others with he same value.

I would do that for each cell in the chart.

is this possible?

Thanks