Match names & other data from two spreadsheets

  • 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!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!