I have a spreadsheet from a vendor with SSNs only and I need to find the
employee names.

I have a spreadsheet of my own employee data, contaiing SSN, name, hire and
term date.

I need to match the SSN from the first list to the names on the other.

Do I need to keep the info in separate spreasheets or can I combine the data
into 1 spreasheet and still have it find matches? Either way, how can I find
out which name goes with the list of SSNs the vendor provided me?