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

M

Mark Christensen

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
 
N

Nick Hodge

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

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy certain rows to new worksheet 1
how to populate a range with another range of data ? 2
Merging Data from two rows into one 1
Copying rows identified by countifs function to seperate worksheet 6
correlating and summing data from multiple spreadsheets 1
moving rows to another sheet 3
bringing in data from another worksgroup to a current workgroup 6
Auto Copy Data from one worksheet to another 1

Top