I want to compare two spreadsheets against using email address and if the email address matches then take information from a cell and add it the the 2nd sheet.
Example Sheet columns:
- ID
- First name
- Last name
- Email address
- City
- State
Sheet 2:
- Account ID
- First Name
- Last name
- City
- State
I want to add Account ID to Sheet one where the emails match
VLOOKUP
. Do the spreadsheets need to be separate files, or can you combine both spreadsheets into a single workbook?