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
- Smartsheet Customer Resources
- 62.2K Get Help
- 359 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 135 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!