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
>