how do I merge two files?
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 |
how do I merge two files?
Try VLOOKUP.
-- David Biddulph "Jon" wrote in message ... 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 |
how do I merge two files?
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 |
All times are GMT +1. The time now is 07:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com