'Lock' part of formula when copying from one cell to another
I am using in one of my spreadsheet a formula referencing to the column title (matching how many times it is listed in another sheet, to be precise).
So if, in the row2 of the sheet "Data", the 1st line/title(B1) of my column(B) is present at least one time, it write "present", otherwise it write "absent". This is working without problems.
The problem happens when I try to use this formulta for the next row, if I paste it in B3, it looks like:
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)
Thank you very much !