aligning 2 spreadsheets

M

mugford

I am trying to align two large spreadsheets (30k rows). They both share 1
column, so I would like to paste data from one sheet into the coresponding
rows of the other sheet where the values in the shared columns are equal. The
problem is that the shared column has some differences between the 2 sheets,
so sorting by the shared value does not align the sheets. help!
 
B

Barry Wainwright [MVP]

I am trying to align two large spreadsheets (30k rows). They both share 1
column, so I would like to paste data from one sheet into the coresponding
rows of the other sheet where the values in the shared columns are equal. The
problem is that the shared column has some differences between the 2 sheets,
so sorting by the shared value does not align the sheets. help!
Click to expand...

Use vlookup to copy matching data from one sheet to the other. This can be
used to look up data where a column in the target sheet exactly matches data
in a column in a look up sheet.
 
M

mugford

Absolutely brilliant! That's been bothering me for close to 4 years now.
Thanks so much!
 
Top