Hi There,

=HLOOKUP(A35,'Master Flash South'!$A$1:$EI$72,MATCH($H$1,'Master Flash South'!$A$1:$A$72,0),0)

I have created the above formula, but when I paste in a new Master Flash South which starts with 139 columns, I then have to remove some columns and cut and paste other columns to be the last columns so my final column is DW, $EI$72 changes to $CZ$72 so the Hllokup no longer finds the final 22 columns.

If it was just 1 formula to change, not a problem, but I have over 500 HLookup formulas that all change to $CZ$

Any help gratefully appreciated

Paul