How do I lookup a value in say column and in returning the found

Closed
Sheengle - Sep 14, 2015 at 12:58 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Sep 14, 2015 at 01:11 PM
Hello,


How do I lookup a value in say column and in returning the found value replace the it with a typed value. An example is;

a b c
------------------------
q r
f f
e h
q w
r m

So I am looking for q in column A and if found return the found value q replaced with the

word "new". Instead of returning q I want it to return new in column C.

Your prompt input will be greatly appreciated.

1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Sep 14, 2015 at 01:11 PM
Sheengle, Good afternoon.

Following your example:

....a.....b.......C
--------------------
1 q.....r......=formula
2 f......f......
3 e.....h.....
4 q.....w.....
5 r.....m.....

C1 --> =IF(A1="Q","NEW","")

Is that what you're looking for?
I hope it helps.
0