I want to copy this formula down the page but want the highlighted cell to stay the same how do I go about it =VLOOKUP(A3,'Season '!$B:$AF,MATCH($B1,'Season '!$B$1:$AF$1,0),0) At the moment it changes to the cell I put it in how do I go about stopping it changing ???