Compare data from one column/spreasheet to another?
 

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?

Compare data from one column/spreasheet to another?
 

If you have two Workbooks (files), move one of the Worksheets (tabs in the
file) to the same Workbook. In one of the worksheets go to an empty cell in
the same row as the SSN and use the VLOOKUP function to pull data from the
other worksheet. I would probably use the VLOOKUP on the vendor worksheet
and pull the SSN info from your worksheet.

If you have trouble with VLOOKUP, click on the help link when you pull the
function dialog box up.

"Carrie" wrote:

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?

Compare data from one column/spreasheet to another?
 

Are you intentionally trying to expose yourself to litigation by storing SSNs
in a non-secure environment like Excel?
--
Brevity is the soul of wit.


"Carrie" wrote:

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?