Multiple Find/Replace
Posted by Chris on January 18, 2002 6:39 AM
I'm trying not to do find and replace hundreds of times, working with 3 columns of data.
In column C, I want to find each value that's in column A and replace it with the B column value that's in the same row as A.
A B C
1 10 1
2 19 1
3 15 2
4 13 2
Would become
C
10
10
19
19
Thanks for your help,
Chris