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?


2 Answers 2


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

enter image description here

  • 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. Feb 26, 2019 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! Feb 26, 2019 at 20:00
  • np, if thats all pls mark the answer as solved
    – user0
    Feb 26, 2019 at 20:00

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)))

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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