match and insert from one workbook to another
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!
|