Combining 2 files

[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

 

[Claus Busch]

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.

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

 

[Antek]

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.

That works! Thank you very much.

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

Regards
Antek