how do I merge two files?

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vlookup or some other function that counts rows 0
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Arriving at totals 2
Subtotal - SUM, COUNT NUMBER, 'Live' Formula 5
Adding sequence numbers to paragraphs 0
Copy and Paste Word 2010 0
sumif only seeing one row 3
macOS Office365 Word 0

Top