consolidate and compare workbooks in excel
 

I have a list in excel (version 2003) with employee data that I need to match
to an insurance billing. Both workbooks have Employee names, SS#'s, Insurance
Type and Insurance amounts. I need to combine these 2 workbooks so the data
is arranged in the consolidated workbook side by side according to SS# so I
can compare the insurance amounts for each employee and calculate the
differences.

consolidate and compare workbooks in excel
 

Look at the VLOOKUP function


http://www.contextures.com/xlFunctions02.html

--


Regards,


Peo Sjoblom

"SC Diane" <SC wrote in message
...
I have a list in excel (version 2003) with employee data that I need to
match
to an insurance billing. Both workbooks have Employee names, SS#'s,
Insurance
Type and Insurance amounts. I need to combine these 2 workbooks so the
data
is arranged in the consolidated workbook side by side according to SS# so
I
can compare the insurance amounts for each employee and calculate the
differences.