List Sorting Problem

[Lubellski]

Not even sure how to describe this, so I have not been able to find an answer in the search.

I have 3 columns. A has 5,000 names. B has 5,000 associated emails. C has 1,000 names. I need to match up the email from column 2 with the same names in columns A and C. I need Column C to match alphabetically with Column A, with blank spaces wherever they need to be because Column A has way more names. So I can add an email attribute to the names in Column C. Make sense? THANK YOU!!!!

WHAT I HAVE		WHAT I NEED
MAIN NAME	MAIN EMAIL	TARGET NAME		MAIN NAME	MAIN EMAIL	TARGET NAME
Billy Idol	Billy@	Johnny Cash		Billy Idol	Billy@
Johhny Cash	Johnny@	Dolly Parton		Johhny Cash	Johnny@	Johnny Cash
Elvis Presley	Elvis@			Elvis Presley	Elvis@
Dolly Parton	Dolly@			Dolly Parton	Dolly@	Dolly Parton

[#2 · Accepted solution]

@Lubellski 

You may

=XLOOKUP(<main email>, <main email columm>, <main name column>, "")

same for target name.

[#3]

Thank you Sergei, I knew that someone here would be able to answer this rapidly. So much appreciated!!!