| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How Merge 2 files with same acc# in each file | Excel Discussion (Misc queries) | |||
| merge csv files into spreadsheet | Excel Discussion (Misc queries) | |||
| MERGE 2 FILES | Excel Discussion (Misc queries) | |||
| merge files in Excel? | Excel Discussion (Misc queries) | |||
| How do I merge two files in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
