0

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:

Main "Official Attendance" Sheet

But notice how I have a separate sheet entitled 2/21 General Meeting of all the people who attended that specific event.

Secondary "2/21 General Meeting" Sheet

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?

0

=ARRAYFORMULA(IF(LEN(A6:A), 
 IF(IFERROR(VLOOKUP(A6:A, '1/17 Callout Meeting'!C1:C, 1, 0), )<>"", 1, 0), ))

enter image description here

| improve this answer | |
  • So maybe I'm doing something wrong, but it returns "0" for everyone for me. I added the function to the sheet if you want to view it. – Teddy Meyer Feb 26 '19 at 19:58
  • That was my fault for changing the 1/17 Callout Meeting sheet! I figured it out. Thanks so much for your help! – Teddy Meyer Feb 26 '19 at 20:00
  • np, if thats all pls mark the answer as solved – user0 Feb 26 '19 at 20:00
0

There are a few options you can use. One such option: Use in D2 the following formula

=ARRAYFORMULA(SIGN(IFERROR(MATCH(A2:A,'2/21 General Meeting'!A$2:A,0),0)))
| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.