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
"Jon" wrote:

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