SOLVED

New Contributor

# List Sorting Problem

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 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

# Re: List Sorting Problem

You may

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

same for target name.

# Re: List Sorting Problem

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