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!

Find more posts tagged with

Accepted answers

Mark Cronk

There was a misplaced paren. Try this:

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

Mark

All comments

Mark Cronk

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

lara65236

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!

Mark Cronk

There was a misplaced paren. Try this:

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

Mark

lara65236

Thank you Mark!!

Mark Cronk

Glad you found a solution. Thank you for contributing to the Community.

Mark

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.