Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro | Excel Discussion (Misc queries) | |||
Compare and Calculate Data Between 2 Files | Excel Discussion (Misc queries) | |||
Compare month to month data | Excel Worksheet Functions | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Printing data validation scenarios | Excel Worksheet Functions |