Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Assigning values - EOT
I have already got a solution.
EOT Regards Antek |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assigning values to dates | Excel Programming | |||
Assigning values to words | Excel Discussion (Misc queries) | |||
Assigning values to letters | Excel Worksheet Functions | |||
assigning values to array | Excel Programming | |||
assigning values by intervals | Excel Worksheet Functions |