Vlookup or IF statement


I have one sheet where I have an attendance list. I have another sheet where I have opportunity logging.

From my opportunity logging sheet, I want to do a vlookup (I think ) of the email address to my attendance sheet email address. If they match, I want it to return "Yes" and if no, "No".

Can someone please hep me?

Thank you!

Best Answer

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer ✓

    There was a misplaced paren. Try this:

    =IFERROR(IF(ISTEXT(VLOOKUP(Email@row, {BOSS Workshop Attendance Range 1},1,False)), "Yes", "No"), "No")


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!