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

Amanda Alv

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

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.

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!