I have a list with two columns and about about 75 rows
looks like this:
I have another sheet with about 5000 rows, I want something to find the number on the left (above) and replace it with the number on the right.
So 5 would become 2 and 10 would become 8 etc.
One thing I need to keep in mind is that I need I would need all values replaced at the same time, because if it did it one after the other then all of the 1's would become 2's and then those 2's would turn into 3's
Does that make sense?
If you help me with this i'll give you a karma and i'll owe you one
and i always pay the ones i owe