In L2, put the $ in front of your range reference to lock the table. =IF(COUNTIF($J$3:$J$18,J2)>1,"double","single") then fill the formula