Combining 2 files

  • Thread starter Thread starter Antek
  • Start date Start date
A

Antek

Hi

There are 2 excel files.

One of them contains list of codes in one column
like this:
COLUMN_1
659364-23Q8F
572846-84E5H
465923-59X3S
173529-10T5V
etc.

The second file contains full list of such codes
with additional information in the next column
like this:
COLUMN_1 COLUMN_2
473623-73W4P area_1
854725-81A9C area_5
659364-23Q8F area_2
7r6w53-45O6R area_5
572846-84E5H area_3
465923-59X3S area_9
484726-93M5W area_1
756452-77J8D area_6
763495-23T0U area_2
238574-69I5J area_7
173529-10T5V area_4
etc.

My task is to assign to each code in the file 1
information from the column_2 in the file 2
like this:
COLUMN_1 COLUMN_2
659364-23Q8F area_2
572846-84E5H area_3
465923-59X3S area_9
173529-10T5V area_4
etc.

The files are big so it is not possible to do it manually.

How to do it automatically?
Please help me.

Regards
Antek
 
Hi Antek,

Am Thu, 14 Mar 2013 16:32:54 +0100 schrieb Antek:
One of them contains list of codes in one column
like this:
COLUMN_1
659364-23Q8F
572846-84E5H
465923-59X3S
173529-10T5V
etc.

The second file contains full list of such codes
with additional information in the next column
like this:
COLUMN_1 COLUMN_2
473623-73W4P area_1
854725-81A9C area_5
659364-23Q8F area_2
7r6w53-45O6R area_5
572846-84E5H area_3
465923-59X3S area_9
484726-93M5W area_1
756452-77J8D area_6
763495-23T0U area_2
238574-69I5J area_7
173529-10T5V area_4
etc.
Click to expand...

open both files and try in B1 of file1:
=VLOOKUP(A1,[Workbook2.xlsx]Sheet1!$A$1:$B$1000,2,0)
Modify workbook name and sheet name and copy the formula down.
When you close file 2 the path will be adapted.


Regards
Claus Busch
 
open both files and try in B1 of file1:
=VLOOKUP(A1,[Workbook2.xlsx]Sheet1!$A$1:$B$1000,2,0)
Modify workbook name and sheet name and copy the formula down.
When you close file 2 the path will be adapted.
Click to expand...

That works! Thank you very much.

How could I learn to write such formulas on my own?
Is there any simple tutorial?

Regards
Antek
 
Back
Top