Thread: How to combine two data sets with one category of variable in com.

Originally Posted by Brown

I want to take to sets of ID numbers with different associated data and
combine them on one sheet.

How do I do this?

Here is how I interpret your post.

In sheet 1, you have the following entries:

A1:A100 -- contains your ID numbers
B1:B100 -- contains the first set of data associated with the ID numbers

In Sheet 2, you have the following entries:

A1:A100 -- contains your ID numbers (let us assume that the order which
the ID numbers appear in Sheet 2 is not the same order as the ID
numbers in Sheet 1).
B1:B100 -- contains the second set of data associated with the ID numbers

In Sheet 1, you can combine all your data as follows:

A1:A100 -- contains your ID numbers
B1:B100 -- contains the first set of data associated with the ID numbers
C1:C100 -- contains the second set of data associated with the ID numers.
(these will be taken from Sheet2!B1:B100)


To combine all the data in Sheet 1, enter this formula in Cell C1

=vlookup(A1,Sheet2!$A$1:$B$100,2,0)

and copy down until C100.

Hope this is what you are looking for.