how do I merge two files?

[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!

 

[David Biddulph]

Try VLOOKUP.

 

[Shane Devenshire]

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