Function to check box if lookup is true
Is it a possibility where a column contains checkboxes, for a function to sit behind that that if a lookup to another sheet returns a true value, the checkbox is ticked?
Specifically for the lookup to be:
On Sheet1: If the value in col ID and the date in col Next Inspection Date appear in sheet2 (below) in the cols 'ID_user' and also col 'until' --> that the checkbox on sheet1 is ticked.
Thanks for any assistance
Help Article Resources
Check out the Formula Handbook template!