SOLVED
Home

Formula Help

%3CLINGO-SUB%20id%3D%22lingo-sub-311693%22%20slang%3D%22en-US%22%3EFormula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-311693%22%20slang%3D%22en-US%22%3E%3CP%3EI%20run%20a%20pick-up%20basketball%20program%20at%20a%20local%20gym.%20We%20started%20requesting%20everyone%20who%20plays%20to%20sign%20a%20waiver%20form.%20I%20need%20an%20easy%20way%20to%20see%20if%20guys%20walking%20in%20have%20signed%20this%20form%20or%20not%20without%20asking%20every%20single%20person.%20We'll%20have%20100%2B%20guys%20throughout%20a%20few%20months%20showing%20up.%20I%20was%20looking%20to%20manage%20this%20on%20excel%20rather%20than%20shuffling%20through%20papers.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20idea%20was%20to%20record%20names%20of%20those%20who%20signed%20the%20waiver%20on%20one%20spreadsheet%20and%20to%20record%20daily%20attendance%20on%20another.%20Is%20there%20a%20way%20I%20can%20type%20in%20a%20name%20on%20my%20attendance%20sheet%20and%20excel%20tell%20me%2C%20through%20a%20formula%2C%20whether%20that%20name%20exists%20on%20the%20other%20sheet%20containing%20everyone%20who%20signed%20the%20waiver%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-311693%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-313152%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-313152%22%20slang%3D%22en-US%22%3E%3CP%3EThat%20is%20exactly%20what%20I%20was%20looking%20for.%20I%20appreciate%20all%20your%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-312759%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-312759%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20want%20to%20have%20separate%20columns%20for%20first%20and%20last%20name%20I'd%20then%20combine%20them%20using%20the%20%26amp%3B%20operator%20as%20per%20the%20attached.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-312362%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-312362%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9832%22%20target%3D%22_blank%22%3E%40Wyn%20Hopkins%3C%2FA%3E%3C%2FP%3E%3CP%3EYes%20that%20does%20work!%20Thank%20you!%3C%2FP%3E%3CP%3ECould%20you%20use%20the%26nbsp%3B%3CEM%3Eifs%26nbsp%3B%3C%2FEM%3Efunction%20for%20adding%20last%20names%20in%20a%20separate%20column%3F%20Or%20would%20that%20overcomplicate%20the%20process%3F%3C%2FP%3E%3CP%3EWe%20have%20several%20guys%20with%20either%20the%20same%20first%20or%20last%20name.%20I%20keep%20them%20in%20separate%20columns%20for%20the%20sake%20of%20organization.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-312157%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-312157%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F262208%22%20target%3D%22_blank%22%3E%40nstrong%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWould%20something%20like%20the%20attached%20file%20work%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
nstrong
New Contributor

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?

 

Any help would be appreciated.

4 Replies
Solution

Hi @nstrong

 

Would something like the attached file work?

@Wyn Hopkins

Yes that does work! Thank you!

Could you use the ifs function for adding last names in a separate column? Or would that overcomplicate the process?

We have several guys with either the same first or last name. I keep them in separate columns for the sake of organization.

Hi

 

If you want to have separate columns for first and last name I'd then combine them using the & operator as per the attached.

 

 

That is exactly what I was looking for. I appreciate all your help!

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
18 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies