copying cells down the page

gazza uk

New member
Joined
May 29, 2014
Messages
41
Reaction score
0
Points
0
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 ???
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
Just add a $ between the B and 1

=VLOOKUP(A3,'Season '!$B:$AF,MATCH($B$1,'Season '!$B$1:$AF$1,0),0)

The $ "freezes" the column and/or row it is place in front of. This is called Absolute referencing.
 
Top