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.
Help Article Resources
Check out the Formula Handbook template!