Excell find in a cell some text

[Closed]
Report
Posts
1
Registration date
Friday September 7, 2012
Status
Member
Last seen
September 7, 2012
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,
I am trying to find in a cell some text. I would want for example in D1 to see if it had: Low Low, if so put a 1 in the E1; High High, put a 1 in E1; MFT, put a 1 in E1, Purge, put a 3 into E1, E-stop, put a 2 into E1; Low put a 2 into E1; High, put a 2 into E1.

Any help? Please.


1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
you can use an if statement for that
in E1 you can have
=IF(D1="LOW LOW", 1,"")