Thanks RagDyer,

Your answer works like a charm. There was one thing I forgot to tell you,
which I can take care of, is that some SSN's have duplicates on File1 which I
guess your formula will take the first one found? Anyway, it doesn't matter
because I will do a quick find match and eliminate the duplicates before
running your formula.

Also, your formula specifies sheet 1 and sheet 2 so I put the two worksheets
in the same file but if I need to use your formula for two seperate
workbooks, can you tell me where in your formula to put the names of the
workbooks? File1 and File2.

Another minor thing is that this formula will not get row A (headers) but
again this is not the formula's fault because row A doesn't have a SSN. I
will just copy paste and do a quick eyeball test.

Thanks a lot,
--
Thank You!


"RagDyer" wrote:

A simple set of Vlookup formulas will do the job.

Assumptions:
Datalist on Sheet1 starts in Row2, from A2 to C(whatever).

Datalist on Sheet2 starts in Row2 and goes from A2 to D100.

On Sheet1, enter this formula in D2:

=IF(ISNA(MATCH($A2,Sheet2!$A$2:$A$100,0)),"",VLOOK UP($A2,Sheet2!$A$2:$D$100,COLUMNS($A1:B1),0))

Copy across to F2,
Then select D2:F2, and copy down as needed.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"maijiuli" wrote in message
...
Hello,

I have a project to match SSN's between 2 workbooks and insert columns
from
one sheet to another.

Example:

File1
Column A = SSN, Col B = Salary, C = DOB

File2
Col A = SSN, B = Address, C = State, D = Zip

I need to take SSN from file2 and find it in file1. If found match then
copy and paste columns B-D of file2 to end of record on file1.

Is there a formula for this type thing.
--
Thank You!