Comparing Data

[ksl]

If I have one spreadsheet with 3 columns, then 3 more columns, and I want to make sure the data matches up. Column A matches D and column B matches E...etc. How would I do this?

Basically I have one spreadsheet....I downloaded a database and added it to the spreadsheet I already had. I need to make sure everything matches. I need to make sure the spreadsheet I already had (which consists of 3 columns) matches up to the database I downloaded (which is 3 columns). I copied and pasted everything on to one spreadsheet.

[mudraker]

I am assuming you want to compare columns a,b,c in row 1 with columns d,e,f in row 1.

If this is correct then in a blank column try this formula

=IF(A1&B1&C1=D1&E1&F1,"","Error")

Copy fourmula down
then use Auto Filter to find the cells that have error in them