Formula Assistance

[tglstar]

We have two large spreadsheets and both contain a common SS field. I need to
combine both sheets by the ss field. They don't have uniform formatting or
columns throughout. I have tried a Pivot Table and vlookup to no avail. HELP!

 

[Otto Moehrbach]

Be more specific. Say you have one row in one sheet and one row in the
other sheet, both rows have the same SS.
In what columns in which sheets are the SS numbers?
What columns from which sheet do you want put into what columns of the other
sheet? Otto