Combining data


A

AmyE

I have information on employees in 2 spreadsheets. Is there a way to link
all data for a certain SS#. Basically I want all data to be side by side so
I can compare the data. I'd like to have SS#, Data from SS1, Data from SS2
as my columns. It's taking me forever to go through and make sure the data
i'm comparing is for the same person.
 
Ad

Advertisements

M

Max

Data assumed in cols A to C (say), in row2 down in both Sheets1/2, with col A
= key col (SS#)

In Sheet1,
Put in say, E2:
=IF(ISNA(MATCH($A2,Sheet2!$A:$A,0)),"",INDEX(Sheet2!A:A,MATCH($A2,Sheet2!$A:$A,0)))
Copy E2 to G2, fill down to the last row of data in col A to return matching
rows from Sheet2 for easy comparison.

You can do a similar construct in Sheet2 to pull over matching rows from
Sheet1 for Sheet2's SS# (Just change "Sheet2" to "Sheet1" in the formula
above)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top