Find Value in 1 column based on another column then replace with value of yet another.

[johanbosman]

Hi All Guru's

Ok what I have is an excel csv (XLS) for this forum.

I have column J with city names without duplicates also Column I with the number of the city in Column J

Now in column C I have cities (B and C is the same just for me to have a copy of C when values is changed)

I would like C to find the values in J and then replace C with the Number in I.

This is just a sample file, C has about 12000 rows in the complete file.

Will something like this be possible ?

On another thread I found something similar than what I wanted to do, but I can't get the code to work, I keep getting errors.
Im not sure if Im allowed to link to the thread , but Im gonna try : http://www.excelforum.com/excel-prog...n-another.html

Thank you all.

Johan