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



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

  • Tamara Gordon Berlik
    Tamara Gordon Berlik ✭✭✭✭
    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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!