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