Replace a value in a column with related value in a Named Range

Dear Friends,

In a work book which consists some 48500 records, column A consist data like this:
Col A
1
1
1
1
2
2
2
2
2
15
15
15
15
18
18
18
18
....AND SO ON (i.e. numerals already sorted A-Z).

And I named a range (Ex. Publisher) in another worksheet with the following sample data:
col1 / col2 / col3
1 / data / Harpercollins
2 / data / McGrawHill
3 / data / Concept Publishers
4 / data / Simon Lloyd Pub
....... and so on.

Now just I would like to replace the above col3 with data in worksheet column A. i.e. All 1 should be replaced with Harpercollins. All 2 should be replaced with Mcgraw Hill.

Besides, as my data table is already sorted by col A, I would like to delete the duplicate entry in Col A. (For example, All 1 should be deleted and only once the Harpercollins should appear in the first column of the concerned row). So that the repeated values can be avoided.

Can any one please help me.

Thanks in advance.

acsishere.