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

Closed
Report
-
Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
-
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 reply

Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
147
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.