Merging data from one worksheet to another when rows don't match

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mark Christensen - 21 Nov 2006 17:29 GMT

Hello,

I have 2 separate worksheets. Worksheet 1 has 780 rows; worksheet 2 has 1779
rows. All 780 rows of sheet 1 are contained within sheet 2, but not
together - they are scattered among the 1779 rows. Column C of worksheet 1
has data for each of the 780 rows that I need to transfer to the
corresponding row in worksheet 2. How can I automate this process so I don't
have to go line by line and manually add the Column C data to worksheet 2. I
hope this makes sense. TIA.

Mark

Reply to this Message

Nick Hodge - 21 Nov 2006 20:23 GMT

Mark

I think you're seeking a VLOOKUP function, but we may need a little more
info on the 'key' to your data, but lets say in columnA on both sheets you
have an item number that identifies the row, you could in C1 on sheet2 enter

=VLOOKUP(A1,Sheet1!$A$1:$C$720,3,FALSE)

This would return the data in column C in sheet1 where the item number in
column A of sheet1 matched the data in A1 on sheet2

You could then just fill that down

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
www.nickhodge.co.uk

> Hello,
>
[quoted text clipped - 7 lines]
>
> Mark

Reply to this Message

Mark Christensen - 21 Nov 2006 20:27 GMT

Nevermind. Just finished doing it manually. Not as bad as I expected.

> Hello,
>
[quoted text clipped - 7 lines]
>
> Mark

Reply to this Message