Spreadsheet A contains a list of names (in two columns, lastname, firstname). Spreadsheet B contains names (lastname, firstname) plus email address, an ID number, supervisor name and other data.
I need to associate the additional data (email address, ID number, supervisor name, etc.) with the list of names in Spreadsheet A.
To be specific: Sheet 1 has lastname in column A, firstname in column B. I need to find/import/paste the data from Column A in Sheet 2, next to the names in Sheet 1.
Any suggestions would be very welcome. Thanks!