Compare and merge two workbooks?

[hlpoindexter]

I have two workbooks. Each contains a column of data (social security
numbers.) I need to merge the workbooks and include data from one
workbook (scores) to the other workbook. If there is no score for a
particular ssn, the score needs to return a zero.

I'm using Excel 2002. I figured I could use compare and merge but that
option is grayed out.

Any suggestions?

Thanks. Heather