I have a very overwhelming and large attendance sheet of 350+ people that I need to keep track of. I have a very simple attendance record of 0 if you weren't there and 1 if you were. For one of our events, in particular, people sign in through a Google sheet document. I would like to be able to take the names of the people that I have in one sheet and add a 0 or 1 to the "main" attendance sheet if their name appears on the sign-up sheet. Is there a formula that I could use to do this?
I have created a "mock" attendance record of something similar to what I need. Here are the images:
But notice how I have a separate sheet entitled 2/21 General Meeting of all the people who attended that specific event.
So for the "Official Attendance" sheet, I would like to add a 1 next to Bob Smith, etc5, etc11, etc2, and etc12 and a 0 to everyone else in the 2/21 General Meeting column.
Is this possible? How would I do this?
Best Answer