Excell find in a cell some text

Closed

mcarcanague

Posts: 1
Registration date: Friday September 7, 2012
Status: Member
Last seen: September 7, 2012

- Sep 7, 2012 at 12:30 AM
rizvisa1

Posts: 4479
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: May 5, 2022

- Sep 10, 2012 at 09:45 AM

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.

Excell find in a cell some text
Excel if range of cells contains specific text then return value ✓ - Forum - Excel
Excel file path in cell - Guide
Excel vba msgbox when cell meets criteria ✓ - Forum - Excel
Excel formula if two cells match return value from third ✓ - Forum - Excel
Excel color row if cell contains text ✓ - Forum - Excel

1 reply

Answer 1 / 1

rizvisa1

Posts: 4479
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: May 5, 2022

769
Sep 10, 2012 at 09:45 AM

you can use an if statement for that
in E1 you can have
=IF(D1="LOW LOW", 1,"")

Subscribe To Our Newsletter!