IF cell contains certain text return value
If your row with the text was row 1, and you wanted row 2 to have
Doing/Checking in it, type the following in cell B1 and copy it along:
=IF(OR(A1="Check",A1="Checking"),"Checking","Doing ")
"Eán" wrote:
I have a row containing various text including the words 'Check' &
'Checking'; in a separate row I would like to identify all the cells which
include 'Check' or 'Checking' and return the text "Checking" if it contains
either 'Check' or 'Checking' or "Doing" if it doesn't.
Hope this makes sense?
Many thanks
|