| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
match and insert from one workbook to another
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trying to use INDEX and MATCH to insert a value w/ multiple criter | Excel Worksheet Functions | |||
| Trying to match certain fields from 1 workbook to another | Excel Discussion (Misc queries) | |||
| I want to match and insert info on 2 different sheets | New Users to Excel | |||
| Lookup then Match and insert value from next column | Excel Worksheet Functions | |||
| Index/Match to look up a value in one workbook and insert it into. | Excel Discussion (Misc queries) | |||
Threaded Mode
