View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default 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!