how to combine multiple files in ms excel

[Guest]

how to combine 2 files become another single file.
example:file 1: ........A........B.......
name address
combine with

file 2: ............A...........B...............C
name address phone

so,
will become:
file 3: ...........A............B.............C
name address phone

 

[JulieD]

Hi

(similar to a question yesterday)
if file 1 contains ALL of the names as file 2 (and some extra) and file 2
has no additional names then,
in
file 1 in column C use the formula of
=VLOOKUP(B2,sheet2!$B$2:$C$1000,2,0)
this says, match up the value in B2, with the list in Sheet2 (i.e. the
location of your file 2) and return the phone number where there is an exact
match.

you can then select this new column in file 1 and copy / edit - paste
special, values, to change the formula to values.

Cheers
JulieD