Hey everybody
I will try keep this short and sweet...
As you should be able to see in the attachment I have 3 columns
The first column is the data I wont to search and replace.
What I want it to do is for every value in A, loop through B and if it finds the Value in A matches that of B then replace the value in A with the value that is in C.
So basically B is like a reference column.
I hope this makes sense. My algorythm is something like this I guess.
Please Login or Register to view this content.
Bookmarks