SOLVED

List Sorting Problem

%3CLINGO-SUB%20id%3D%22lingo-sub-2904174%22%20slang%3D%22en-US%22%3EList%20Sorting%20Problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2904174%22%20slang%3D%22en-US%22%3E%3CP%3ENot%20even%20sure%20how%20to%20describe%20this%2C%20so%20I%20have%20not%20been%20able%20to%20find%20an%20answer%20in%20the%20search.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%203%20columns.%20A%20has%205%2C000%20names.%20B%20has%205%2C000%20associated%20emails.%20C%20has%201%2C000%20names.%20I%20need%20to%20match%20up%20the%20email%20from%20column%202%20with%20the%20same%20names%20in%20columns%20A%20and%20C.%20I%20need%20Column%20C%20to%20match%20alphabetically%20with%20Column%20A%2C%20with%20blank%20spaces%20wherever%20they%20need%20to%20be%20because%20Column%20A%20has%20way%20more%20names.%20So%20I%20can%20add%20an%20email%20attribute%20to%20the%20names%20in%20Column%20C.%20Make%20sense%3F%20THANK%20YOU!!!!%3C%2FP%3E%3CTABLE%20width%3D%22594%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22265%22%3EWHAT%20I%20HAVE%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22265%22%3EWHAT%20I%20NEED%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EMAIN%20NAME%3C%2FTD%3E%3CTD%3EMAIN%20EMAIL%3C%2FTD%3E%3CTD%3ETARGET%20NAME%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EMAIN%20NAME%3C%2FTD%3E%3CTD%3EMAIN%20EMAIL%3C%2FTD%3E%3CTD%3ETARGET%20NAME%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EBilly%20Idol%3C%2FTD%3E%3CTD%3E%3CA%20href%3D%22mailto%3ABilly%40%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EBilly%40%3C%2FA%3E%3C%2FTD%3E%3CTD%3EJohnny%20Cash%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EBilly%20Idol%3C%2FTD%3E%3CTD%3E%3CA%20href%3D%22mailto%3ABilly%40%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EBilly%40%3C%2FA%3E%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EJohhny%20Cash%3C%2FTD%3E%3CTD%3E%3CA%20href%3D%22mailto%3AJohnny%40%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EJohnny%40%3C%2FA%3E%3C%2FTD%3E%3CTD%3EDolly%20Parton%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EJohhny%20Cash%3C%2FTD%3E%3CTD%3E%3CA%20href%3D%22mailto%3AJohnny%40%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EJohnny%40%3C%2FA%3E%3C%2FTD%3E%3CTD%3EJohnny%20Cash%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EElvis%20Presley%3C%2FTD%3E%3CTD%3E%3CA%20href%3D%22mailto%3AElvis%40%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EElvis%40%3C%2FA%3E%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EElvis%20Presley%3C%2FTD%3E%3CTD%3E%3CA%20href%3D%22mailto%3AElvis%40%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EElvis%40%3C%2FA%3E%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EDolly%20Parton%3C%2FTD%3E%3CTD%3E%3CA%20href%3D%22mailto%3ADolly%40%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EDolly%40%3C%2FA%3E%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EDolly%20Parton%3C%2FTD%3E%3CTD%3E%3CA%20href%3D%22mailto%3ADolly%40%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EDolly%40%3C%2FA%3E%3C%2FTD%3E%3CTD%3EDolly%20Parton%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2904174%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2904201%22%20slang%3D%22en-US%22%3ERe%3A%20List%20Sorting%20Problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2904201%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1200833%22%20target%3D%22_blank%22%3E%40Lubellski%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DXLOOKUP(%3CMAIN%20email%3D%22%22%3E%2C%20%3CMAIN%20email%3D%22%22%20columm%3D%22%22%3E%2C%20%3CMAIN%20name%3D%22%22%20column%3D%22%22%3E%2C%20%22%22)%3C%2FMAIN%3E%3C%2FMAIN%3E%3C%2FMAIN%3E%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3Esame%20for%20target%20name.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2904224%22%20slang%3D%22en-US%22%3ERe%3A%20List%20Sorting%20Problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2904224%22%20slang%3D%22en-US%22%3EThank%20you%20Sergei%2C%20I%20knew%20that%20someone%20here%20would%20be%20able%20to%20answer%20this%20rapidly.%20So%20much%20appreciated!!!%3C%2FLINGO-BODY%3E
New Contributor

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 NAMEMAIN EMAILTARGET NAME MAIN NAMEMAIN EMAILTARGET NAME
Billy IdolBilly@Johnny Cash Billy IdolBilly@ 
Johhny CashJohnny@Dolly Parton Johhny CashJohnny@Johnny Cash
Elvis PresleyElvis@  Elvis PresleyElvis@ 
Dolly PartonDolly@  Dolly PartonDolly@Dolly Parton
2 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@Lubellski 

You may

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

same for target name.

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