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?
Help Article Resources
Check out the Formula Handbook template!