# Formula for name match

1. ## Formula for name match

Hi everyone,

I need help with a formula that can identify names on one sheet and create true value to the main as the master sheet.
This is based on google classrooms with students submitting work. When they submit work, it shows the timestamp and names.

I would like to create a master list of all the students throughout the whole grade and add a value complete or incomplete by matching up names from the submission sheet.

Ideally, the master sheet will include weekly date task submission and have the column confirm their completion. The original google classroom sheet does not identify incomplete task.

2. ## Re: Formula for name match

Maybe

=COUNTIFS(Sheet1!B:B,A2,Sheet1!C:C,B2)>0

3. ## Re: Formula for name match

Thank you so much for the code. I created the code but it keeps saying true or false. Can I change the word true or false to complete or incomplete?

4. ## Re: Formula for name match

Originally Posted by Phuocam
Maybe

=COUNTIFS(Sheet1!B:B,A2,Sheet1!C:C,B2)>0
Can we have the word as complete or incomplete?

5. ## Re: Formula for name match

Use an If function, to display as Complete or Incomplete. IF(COUNTIFS(Sheet1!B:B,A2,Sheet1!C:C,B2)>0=TRUE,"Complete","Incomplete")

6. ## Re: Formula for name match

=IF(Sheet2!B3=Sheet1!B2:C4, "yes","No")

There are currently 1 users browsing this thread. (0 members and 1 guests)