Hi,
How can I found a some value and replace it?
Example:
A1=A
A2=B
A3=C
B1=1
B2=2
B3=3
I have a imput cell D1 and D2.
I add in D1 value "A" and D2 value 2. I need that excel can found this cell B1 and replace it by value "2".
D1 is value what I need to find and D2 what is a value whitc will replace this old value 1.
Or can I decrease or increase the value by same way.
Any ideas?
Bookmarks