merging data from 2 files or 2 worksheets

[jeff]

Hello,

I'm trying to merge data in Excel. I have 2 datasets with one common
variable. I've tried several different approaches, and none works. Is
it possible to merge in Excel? Or is the program not that
sophisticated? If I had SAS or SPSS it would be snap.

Thanks.

JK

 

[JE McGimpsey]

I'm trying to merge data in Excel. I have 2 datasets with one common
variable. I've tried several different approaches, and none works. Is
it possible to merge in Excel? Or is the program not that
sophisticated? If I had SAS or SPSS it would be snap.

Certainly it's possible to merge datasets. Take a look at the VLOOKUP()
function.

Post back with details if that doesn't help.

 

[jpdphd]

Hello,

I'm trying to merge data in Excel. I have 2 datasets with one common
variable. I've tried several different approaches, and none works. Is
it possible to merge in Excel? Or is the program not that
sophisticated? If I had SAS or SPSS it would be snap.

Thanks.

JK

I don't know of any built-in command that would do this (but, I don't
know everything!).

If every instance of the common variable is in both datasets, you
could simply order the two data sets by the common variable, and then
copy the extra data from one set to the other.

If that is not true, I think you will have to do some serious formula
writing or make a macro...

jpdphd