Hi,

I've been trying to get my head around an absolute value problem but no luck.

I'm trying to get an IF statement with absolute values to copy down a few thousand cells in a spread sheet but can't think of a way to do it other than to manually go into each cell and change the reference.

The formula is:

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

What I want to achieve is the first absolute value ($M$1222) to change each time I copy it down the column. So if I drag the formula down the column, the value $M$1222 will automatically update to $M$1223, $M$1224 and so on. The formula is then copied across the rest of a table which has about 100 columns so the value in column M needs to stay absolute as it is comparing its value to values in different cells across row 11.

Can this be done or have I painted myself into a corner? Do I have to use VBA or can it be done without VBA?


Cheers