How to combine two excel sheets into one

  • Thread starter Thread starter Dragana
  • Start date Start date
D

Dragana

How to combine two excel sheets into one using the value
in the common column
 
You can retrieve the value from specific columns and merge them onto another
worksheet by using the =vlookup() command.

=vlookup(a1,sheet2!$a$1:$x$9999,3,false)

would use the value in A1 to look through sheet2 (A1:A9999). If it doesn't find
a match, you'll get a #n/a back.

but if it there is a match, you'll get the 3 column over (C) returned.

Take a look at =vlookup() in excel's help for lots more info--or post back with
a more specific question. (I'm sure you'll get a better answer.)
 
You must log in or register to reply here.

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

Combining spread sheets with common fields 3
combine rows with similar data, but different fields in excel 1
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Combining Text From Cells 3
Combine Data 1
Combine Multiple Worksheets 2
Remove date format? 3
How to combine two different excel files 1

Back
Top