Hi Aflatoon,

The problem I have with that solution is the value in cell $M$1222 needs to be constant as this is then copied across the table to the other cells.

If I don't absolute the whole value, I then have to make the value absolute in every other cell manually.

This is a sample of how the rest of the spread sheet looks going across the table from column U:

=IF($M$1222=U$11,$H1222,0)
=IF($M$1222=V$11,$H1222,0)
=IF($M$1222=W$11,$H1222,0)
=IF($M$1222=X$11,$H1222,0)

So when I go down to the next row, the formula should be (going across the table again):

=IF($M$1223=U$11,$H1223,0)
=IF($M$1223=V$11,$H1223,0)
=IF($M$1223=W$11,$H1223,0)
=IF($M$1223=X$11,$H1223,0)

Is there any way to make the formula work?