Is it possible...

J

Joe Mamma

Is it possible to merge two excel files together if there
is something that ties them together? I have two excel
files that i need to merge together by "Location Name".
Each file has different information for each location and
I need to get them together into one file. Can HLookup or
VLookup be used? I cannot copy/paste, not all of the
Locations in one file are in the other and these files are
too large for me to sift through manually. Any help would
be greatly appreciated.
Thank you!
 
F

Frank Kabel

Hi
yes this is possible. Probably VLOOKUP will work for you.
If you could outline the layout of your files with some
more detail a more specific answer would be possible
 
G

Guest

I have two files. One has 24 columns of information and
the other has 3 columns. I need to merge these two xls
files together into one by using the Location Name column
(it's in both worksheets).
 
F

Frank Kabel

Hi
still not that much detail :)
Some assumptions:
- files are named file1.xls (24 columns) and file2.xls (3 columns) (you
don't just mean two different tabsß)
- data is on sheet1 for both files
- both files are open! (Otherwise you may have to add the path
information)
- column A stores the location name
- we will 'copy' the columns B+C from the 3 column sheet to the 24
column sheet

Enter the following formula in cell Y1
=VLOOKUP(A1,'[file2.xls]sheet1'!$A$1:$C$1000,2,0)

in Z1 enter
=VLOOKUP(A1,'[file2.xls]sheet1'!$A$1:$C$1000,3,0)

copy both formulas down for all rows. After this select columns Y:Z and
copy the contents.
Goto 'Edit - Paste Special' and choose 'Values' to remove the formulas
 
Top