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
Bookmarks