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!!
Best Answer
-
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.
Answers
-
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.
-
Thank you for the help and idea!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!