Consolidating multiple files into 1 target

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

I have 4 different files that I want to merge into one.
The data set is gigantic so I wanted to create a macro to
do the dirty work for me. The three files each of keys.
1 file is 1 key the 2nd file is the 2nd key and the 3rd
file is the one that matches the first and second keys to
give me a name. Now I want to get the information from
all of these onto one file. So basically im asking is how
to go about matching them up. I need them to be matched
and then the corresponding row be added into the already
existing row in the target file. THANK YOU!!!
 
paste the first and second keys into a single file, (column A and Column B)

then make a concatenated column in column C of the first and second key
(Column A and B).

Make a similar column in column A of the third file (insert a new column A).
(if necessary)

Now use the vlookup function using the values in column C of the combined
file to lookup the values in the third file using column A as the key.
 
Back
Top