Forum Discussion
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 |
You may
=XLOOKUP(<main email>, <main email columm>, <main name column>, "")same for target name.
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!!!
