Find > Replace Textual Values across entire records

L

Lynden

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.
 
T

Tom Ogilvy

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.
 
Top