Adding Checkboxes automatically value based on index match

[nigelog]

I use these checkboxes to allow user to remove unnecessary customers for reporting. To save time though if they already appear on a list then the checkbox should be automatically "checked"

The macro creates a unique list from a large dataset and then adds a checkbox

For Each cell In rng2
    
    With ActiveSheet.CheckBoxes.Add(cell.Offset(0, 1).Left, _
     cell.Top, cell.Width = 30, cell.Height)
     .LinkedCell = cell.Offset(0, 1).Address(External:=T)
     .Interior.ColorIndex = 37
     .Caption = Range(.LinkedCell).Row
    End With

 

Next cell
End With

I have been trying with a helper column linked to the checkbox but the macro just overwrites the helper column

 "= IF(ISERROR(MATCH("A2","H2:H100" ,0)),"FALSE","TRUE")"

I tried an If statement but couldn't phrase the required syntax. Any ideas appreciated