If Email@Row matches an email on a different sheet, display "yes"

swirt009

Hi All,

I'm hoping for some help!

I have two sheets, "Program Planning Guide Submission" and "Main Tracking" both contain email addresses.

I need a formula for when someone is added to the "Program Planning Guide Submission" sheet, a column checks if the email is already on the "Main Tracking" sheet. If it is, the column should display "Yes", if not, the column should display "No".

This is the formula I tried and all results display "No" even though I know some emails are matching.

=IFERROR(IF(MATCH(Email@row, {Main Tracking Email}, 0), "Yes"), "No")

Thanks!

Paul Newcome

Try an IF/COUNTIFS instead:

=IF(COUNTIFS({Main Tracking Email}, @cell = Email@row) = 0, "No", "Yes")

Paul Newcome

Try an IF/COUNTIFS instead:

=IF(COUNTIFS({Main Tracking Email}, @cell = Email@row) = 0, "No", "Yes")

swirt009

That worked, thank you!

Paul Newcome

Happy to help. 👍️

JayCee

This is great! @Paul Newcome what are you putting in the "@cell" section of the formula?

Paul Newcome

@JayCee You would just leave it as is. Here is more information on @row and @cell.

https://help.smartsheet.com/articles/2476491-create-efficient-formulas-with-at-cell#toc-use-cell-to-perform-smarter-cell-calculations