I extracted data from two different AD domains to a CSV. The headers are Name, samAccountName1, samAccountName2, mail1, mail2. I need to match mail1 against mail2. mail1 has 1372 rows of data, mail2 has 60157 rows of data. The rows for mail1 & mail2 do not match up of course.. they are unsorted. How can I find or lookup the matches from the mail1 column to the mail2 column and perhaps sort the data?
Thank you