| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Conditional import of data from other workbook or worksheet
Hey,
What function would I want to use or how would a sample formula look like if I want to merge properties from two workbooks? ExcelFile1: full name and addresses ExcelFile2: full name and phone number Wanted result: ExcelFile1 with a new column containing the right phone number for each employee. Also, how do I reference the other file, or another sheet in the same workbook when building a formula? TIA BoB |
|
#2
|
|||
|
|||
|
cell In excelfile1 C2, if names are in column A:
=VLOOKUP(A2,[excelfile2.xls]Sheet1!$A$2:$B$4,2,FALSE) and fill down! Regards, Stefi €˛Bengt Bergholm€¯ ezt Ć*rta: Hey, What function would I want to use or how would a sample formula look like if I want to merge properties from two workbooks? ExcelFile1: full name and addresses ExcelFile2: full name and phone number Wanted result: ExcelFile1 with a new column containing the right phone number for each employee. Also, how do I reference the other file, or another sheet in the same workbook when building a formula? TIA BoB |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing unopened worksheet into an open Workbook | Excel Discussion (Misc queries) | |||
| How to import data from a password protected Access DB into Excel. | Excel Discussion (Misc queries) | |||
| Import Data Keeps asking for Password | Excel Discussion (Misc queries) | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| Import Excel Data from another workbook or file | Excel Discussion (Misc queries) | |||
Linear Mode
