Both spread sheets have a list of names in column A and Salaries in column E (I could move them so they are side by side) I want 2nd spreadsheet to Match the names from it's own column A to that of the first sheets column A and if they match extract the Salary from the same row. I am basically trying to just compare salaries for each person from last year to this year. There will be some new people who wont match. Any suggestions?