if find values in column then concatenate unique values

Hello everyone,

I am trying to run something equivalent to what a concatenateif function would do.

I have a column of values (names) in column B (fluctuating number of rows) and a table of certain names to look for (cells F2:F7)

What I would like to do is search for these names in the column and return a string containing the tables names that are in the column (separated by commas)
what I currently have is quite lenghty and has to be adapted each time a name is added to the list
the output looks something like "john Doe, Jane Smith, Mike Anderson"

Please Login or Register  to view this content.

Is there a way to simplify this?
even with vba or using Name tables?


thanks

here is one (formula is in H2



Book1.xlsx