Formula for a checkbox
Ok so what I am trying to do is put a formula in the background of a checkbox.
The purpose is the have the formula check a name in a cell, and then compare that value with a list on another sheet. At the moment I have that list typed one name per cell vertically however I would prefer to be able to put the list into a dropdown list to negate having to change the reference range.
If the formula finds a match then I want it to leave the checkbox unchecked, however if no match is found in the list then I want it to tick the checkbox.
If I can put the list in a drop down the I would prefer the formula to make the dropdown list reference absolute so that when the formula fills down it always references the same dropdown.