View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default 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?