MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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


Posted by IML on January 18, 2002 6:43 AM

Could you get away with
=INDIRECT("b"&C1)
in column d?

good luck