I run a pick-up basketball program at a local gym. We started requesting everyone who plays to sign a waiver form. I need an easy way to see if guys walking in have signed this form or not without asking every single person. We'll have 100+ guys throughout a few months showing up. I was looking to manage this on excel rather than shuffling through papers.
My idea was to record names of those who signed the waiver on one spreadsheet and to record daily attendance on another. Is there a way I can type in a name on my attendance sheet and excel tell me, through a formula, whether that name exists on the other sheet containing everyone who signed the waiver?