How to I replace or substitute multiple unique numeric records in 2 columns
with the related textual value from another column.

For Example:
I would like to replace or substitue Column C & D records with the related
textual value of Column A.

Column A "name" = Textual value
Column B "regnum" = unique id

Column C "sire_num"= unique id relating to Column A "name" - textual value
Column D "dam_num"= unique id relating to Column A "name" - textual value

Looking forward to your help.

Insert a new column D and use a formula

In the new D2:
=if(C2<"",Index(A:A,Match(C2,B:B,0),1),"")
drag down
the column
Select the new column D and do Edit=Copy, then Edit=PasteSpecial and
select values.

now delete the current column C

Repeat with the old Column D.

--
Regards,
Tom Ogilvy



"Lynden" wrote in message
...
How to I replace or substitute multiple unique numeric records in 2
columns
with the related textual value from another column.

For Example:
I would like to replace or substitue Column C & D records with the related
textual value of Column A.

Column A "name" = Textual value
Column B "regnum" = unique id

Column C "sire_num"= unique id relating to Column A "name" - textual value
Column D "dam_num"= unique id relating to Column A "name" - textual value

Looking forward to your help.