I have 2 spreadsheets:

Spreadsheet 1 has column headers labeled LAST, FIRST, STATUS AND BADGE ID. Columns LAST and FIRST are populated with last names and first names respectively. TYPE and BADGE ID are blank.

Spreadsheet 2 has column headers labeled LAST, FIRST, STATUS AND BADGE ID. Columns LAST and FIRST are populated with last names and first names respectively. TYPE is populated with text and BADGE ID is populated with unique numbers.

Spreadsheet 2 has 1900 rows of data and Spreadsheet 1 has 600+. I need to add the TYPE and BADGE data from spreadsheet 2 to the matching LAST and FIRST of spreadsheet 1.

This is driving me crazy. Please help!!