I have two spreadsheets.
One exported from Salesforce with the Salesforce ID, and email address.
The other, a list of email addresses and 15 columns of True/False preference information.
I need to be able to match the email address and bring the salesforce ID from spreadsheet 1 into the matched row in spreadsheet 2.
There are 140,000 rows in Spreadsheet1 and approx 40,000 in spreadsheet 2.