How to combine two excel sheets into one

  • Thread starter Thread starter Dragana
  • Start date Start date
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.)
 
Back
Top