Need to create a formula that pulls back information if it meets a criteria

So currently I have a cell which does the following:

=COUNTIFS(Table1[Dealer Name],'Invoicing Master'!$B$16,Table1[Campaign Date],'Invoicing Master'!E34,Table1[Attended],"Yes")

Which is telling me if an appointment was 'attended' for a specific dealer in a specific month.

This is providing me a value and I need to pull back information if there is a situation where an appointment is attended.

I need to see the surname of the person who attended the appointment in a separate box.

Example:

Surname First Name Attended Month
Jones Bob Yes March

I would therefore like a new cell to display the surname of this person given it has met all the criteria in the initial formula.


Any help is appreciated.