'Lock' part of formula when copying from one cell to another
I am using in one of my spreadsheets a formula referencing the column title (matching how many times it is listed in another sheet, to be precise). Something like, in Cell B2:
So if, in the row2 of the sheet
Data, the first line/title (B1) of my column(B) is present at least one time, it writes
present, otherwise it writes
This is working without problems.
The problem happens when I try to use this formula for the next row, if I paste it in B3, it looks like (Cell B3):
B1 from my original formula becomes
B2 and now refers to the value of the previous row.
How can I keep a variable static whenever I copy/paste the cell ?
(I do still want for the other values to increment)