Hello, I have an yellow area of numbers.
2 5
4 49
7 50
12 51
13 52
23 53
2 90 94 25 54
4 13 95 90 55
7 23 96 94 56
12 25 97 95 57
100 99 98 96 58
97 59
98 60
99 61
100 62
I would like to replace with one move each number.
So for example the area of numbers is:
2,4,7,12,13,23,25,90,94,95,96,97,98,99,I00, want to replace according to those rules:
If number 2 replace with 5
If number 4 replace with 49
If number 7 replace with 50 e.t.c. like green area
How can I do this in Excel?