Attendance Roster Suggestion (part 2)

[jason.hampton]

Team,

The first part of my issue was rapidly solved!

In the attached I would like a structured reference to indicate whether a person is a member, MeetingAttendanceReport (Member column), by comparing their email address to the "roster" page. Basically I've tried several variations of IF & VLOOKUP and not having luck.

This is on the Meeting Attendance Report worksheet column "F".

• Table 1 (MeetingAttendanceReport) Column E lists all attendees by email address, for the bi-weekly attendance
• Table 2 (Roster) Column F - is the 'master list' of members

[Pete_UK]

You can use this formula in F9:

=IF([@[Email (userPrincipalName)]]="","",IF(COUNTIF(Table2[Email Address],[@[Email (userPrincipalName)]]),"Yes","No"))

Hope this helps.

Pete

[jason.hampton]

You can use this formula in F9:

=IF([@[Email (userPrincipalName)]]="","",IF(COUNTIF(Table2[Email Address],[@[Email (userPrincipalName)]]),"Yes","No"))

Hope this helps.

Pete

Thank you! I was close....

Please Login or Register  to view this content.

[Pete_UK]

Yes, but you would have to do:

=IF(VLOOKUP( ... ) = something, "Yes","No")

The

... IF(COUNTIF( ... ) ... in my formula will return a number or zero, and any positive number will be taken as TRUE and a zero as FALSE, so there is no need for a direct comparison with something else.

Hope this helps.

Pete

EDIT: Thanks for the rep, by the way.