Formula for multiple values of text in cell to display text in another column

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Thread title has been updated. I hope it is satisfactory.

Table with data and VLOOKUP? It would be easier to offer a solution if you could post a sample file.

Name	Final Name
Tye Westmark
Cristie Gimble
Tony Sepanski
Starla Buccholz
Keri Oldman
Reimer Douglas
Debra Liming
Marka Kontos
Carol Peterson
Karen Ottison
Joleen Sums
Joseph Ahlf
Brian Mays
Freddy Mercury
Robert Smith
Steve Severin

So, the first column is a list of 16 names. It's a mix of Client Representatives and their assistants. If it says the Client Rep or their assistant, I want the name of the client rep associated with their assistant to show in the adjacent cell.

Name	Final Name
Tye Westmark	Tye Westmark
Cristie Gimble	Tye Westmark
Tony Sepanski	Tony Sepanski
Starla Buccholz	Tony Sepanski
Keri Oldman	Keri Oldman
Reimer Douglas	Keri Oldman
Debra Liming	Debra Liming
Marka Kontos	Debra Liming
Carol Peterson	Carol Peterson
Karen Ottison	Carol Peterson
Joleen Sums	Joleen Sums
Joseph Ahlf	Joleen Sums
Freddy Mercury	Freddy Mercury
Brian Mays	Freddy Mercury
Robert Smith	Robert Smith
Steve Severin	Robert Smith

That is unfortunately not what I need. Let me restate. I unfortunately don't have Excel here on my laptop to make a sample file (it's on my desktop which is being repaired).

I have a file that contains a list of over 5,000 unique items in Column A. Column B contains a person assigned to each unique item. There are 16 persons, so obviously their names repeat. Eight of those persons are client reps, the other 8 are the names of assistants to the client reps. Each client rep gets one assistant. I need to create a formula to check all 16 names and return the client rep. So, for example, if B2 contains Tye Westmark, it would return Tye Westmark, because he's a client rep. If B3 contains Cristie Gimble, the formula should return Tye Westmark, because Cristie Gimble is his assistant. To be clear, the formula needs to check ALL 16 names in each cell in Column B.

Is that more clear?