Syntax problems - What syntax to use with XLOOKUP, FILTER and TEXTJOIN nested functions...

[Voodoowho]

I have 2 worksheets in the same workbook, STAFF and Objectives.
Each tab contains a table...
'STAFF' holds tblStaff and 'Objectives' holds tblObjectives.

The tblOjectives has several headers with each staff member's names (col G:R), under which are cells containing the date that a certain objective name (col B) was added, or blank if not.

On the STAFF tab, tblStaff holds records of the same staff member names (col A) and a column (J) labeled 'Objectives' where I want to return the objective names, separated by a comma, from the tblObjectives for each staff name.

I'm trying to use XLOOKUP, FILTER and TEXTJOINE functions, but I can't get it to work. Is it even possible to do this?

 

[Voodoowho]

I figured it out. I had removed the last names for the records to protect the innocent. Lol! Thank you so much! Beautiful solution!!!
How do I go back and change the names back to first and last name? If I just add the last names back to the tblObjectives and put "" around the outside of the [ ]s on the names, will that fix it?

Again, never mind. I'm pretty thick on Friday. Lol. I think I have it now. Just needed to fix the names and then apply the formula. I'll let you know how it goes. Thanks again!

Yep, that fixed it!! Thank you so very much for your time.

 

[Fluff]

You're welcome & thanks for the feedback.