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
|