how do I merge two files?

  • Thread starter Thread starter Jon
  • Start date Start date
J

Jon

How do I merge

A&D 113
A&D 113
A&D 113
A&D 113
A&D 113
A&D 201
A&D 201
A&D 201

and

A&D 113 TECH
A&D 201 SCHS

to get

A&D 113 TECH
A&D 113 TECH
A&D 113 TECH
A&D 113 TECH
A&D 113 TECH
A&D 201 SCHS
A&D 201 SCHS
A&D 201 SCHS

Thanks in advance!
 
Hi,

Suppose the first set of data is in A1:B100 and the other data Sheet2!D1:E3
(adjust for your sheet names and workbooks)

In cell C1 enter the formula

=VLOOKUP(A1,Sheet2!$D$1:$E$3,2,FALSE)

copy this down as far as necessary.

If this helps, please click the Yes button.

cheers,
Shane Devenshire
 
Back
Top