in the attached ss i am trying to track attendees to a meeting.
I need to match the names and the dates and return YES/NO
I have highlighted in yellow the names that need looking up
Head of AML Models
are one to one, straight matches, for the rest you need to find FCC in the appropriate range
So BMC [C22:C30] returns "no" as the FCC did not attend
So i suppose the find function would need to be utilised