I offered a VBA solution to a poster in another forum which works very well given the "Yipieeeeeee... it works" response I got back.

Poster has zero vb knowledge and even with the workable macro insists on a formula to do the same, for which I am at a loss.

Column A has a list of names which repeat, about 12 names w/ three unique.
Column B has a list of names, all unique.

With one of the unique names from Column A in F1 is there a formula that will list the names adjacent to the name in F1 from the list in column B.

Joe Martin
Silvia Jacob
Nathan Lewis
Joe Samantha
Silvia Jerry
Nathan Britney
Joe Sheila
Silvia Roger
Nathan Randolph
Joe Cherry
Silvia Jerrard
Nathan Monica

So if Joe is in F1 the list should be:

Martin
Samantha
Sheila
Cherry

Regards,
Howard