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

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