Vlookup or IF statement

lara65236

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!

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

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