How to use a Vlookup type function to cross reference two columns

Hi!

I am working on capturing attendance for a large project, which requires cross referencing data from the list of employees email in my sheet (column: "Employee Email") to a column of emails pasted in from an excel sheet (column: "Attendees"). If @row of Column "Employee Email" equals an email in any row of column "Attendees", is it possible to have @row in a third column, "Attendance" state the word "Yes"?

Hopefully that's clear, thank you for any suggestions!!

Find more posts tagged with

Accepted answers

Tamara Gordon Berlik

I would have the Attendance Column be a Check box and use this formula

=IF(ISERROR(MATCH([Employee Email]@row, {Attendees Range 1}, 0)) = true, 0, 1)

This would check the box Attendance if the Attendees Column had a match.

All comments

Tamara Gordon Berlik

I would have the Attendance Column be a Check box and use this formula

=IF(ISERROR(MATCH([Employee Email]@row, {Attendees Range 1}, 0)) = true, 0, 1)

This would check the box Attendance if the Attendees Column had a match.

Amanda Alv

Thank you for the help and idea!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.