Can I use Excel for this merge?
Posted by Steve H on December 15, 2000 7:38 PM
I'm new to excel. I have 2 worksheets , 1 with 500 rows and 1 with 100 rows, and the only common column contains social security number. Can I add columns from the second worksheet to the first worksheet when matching social security numbers are found?????
Posted by CPod on December 15, 2000 8:14 PM
If you have, say, a telephone # in column B on Sheet1 that you what to add to Sheet2 by matching the SS #s (in column A on both sheets) use something like this:
=index(Sheet1!$B$1:$B$1000,match(a2,sheet1!$A$1:$A$1000,0),1)
Put this into row 2 in Sheet2 and copy down the column.
The match function finds the row in sheet1 that matches the SS # in sheet2. The index function returns the value in that row in column B.
