Assigning values
 

Hi

I have another problem today.:-(

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

Assigning values - EOT
 

I have already got a solution.

EOT

Regards
Antek