aligning 2 spreadsheets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mugford - 25 Jan 2007 14:14 GMT

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!

Reply to this Message

Barry Wainwright [MVP] - 25 Jan 2007 15:26 GMT

On 25/1/07 14:14, in article
EDE4EA61-A030-4F79-993C-956DE972F9AB@microsoft.com, "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!

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.

Signature

Barry Wainwright
Microsoft MVP (see http://mvp.support.microsoft.com for details)
The Entourage User's WebLog has moved!
For hints, tips and troubleshooting go to <http://www.barryw.net/weblog/>

Reply to this Message

mugford - 25 Jan 2007 15:56 GMT

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

> On 25/1/07 14:14, in article
> EDE4EA61-A030-4F79-993C-956DE972F9AB@microsoft.com, "mugford"
[quoted text clipped - 8 lines]
> used to look up data where a column in the target sheet exactly matches data
> in a column in a look up sheet.

Reply to this Message

Mac Forum / Applications / Excel / January 2007

aligning 2 spreadsheets