Hi All,

I have got this formula which i'm using, but i only have it on one row at the minute, i want to copy the formula down multiple rows but without changing the Index Match cells only changing one cell reference for example I3 would be become I4.

=IF(I3*1.25>DATA!I60,"DISTBLOCK",INDEX(DATA!I5:I20,MATCH(TEMPERATURES!I3,DATA!J5:J20)))

I have over 100 rows on my worksheet so don't want to have to go down each row and change the cells.

Any help would be appreciated.