Vlookup or IF statement
Hi,
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
-
There was a misplaced paren. Try this:
=IFERROR(IF(ISTEXT(VLOOKUP(Email@row, {BOSS Workshop Attendance Range 1},1,False)), "Yes", "No"), "No")
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Answers
-
Hi @lara65236 ,
You'll need to adjust for your column names but try:
=IFERROR(IF(ISTEXT(VLOOKUP([email address]@row, {attendance sheet email},1,False), "Yes", "No"), "No")
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Thank you Mark,
=IFERROR(IF(ISTEXT(VLOOKUP(Email@row, {BOSS Workshop Attendance Range 1},1,False), "Yes", "No"), "No")))
What am I missing? I get unparseable
Thank you!
-
There was a misplaced paren. Try this:
=IFERROR(IF(ISTEXT(VLOOKUP(Email@row, {BOSS Workshop Attendance Range 1},1,False)), "Yes", "No"), "No")
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Thank you Mark!!
-
Glad you found a solution. Thank you for contributing to the Community.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Help Article Resources
Categories
Check out the Formula Handbook template!