CODEWITHSUNDEEP
excelif-statement
Max Gates-Fleming
Max Gates-Fleming

Reputation: 1

Excel: Formula search for individual word in cells that contain multiple words

I'm trying to mark a list as completed where completed tasks say 'Done' next to them (in Column B). In Column C I am writing the progress of each task in and when completed need to write the date that it was completed (ie "Finished 27/02")

Unfortunately if I include a date in the following formula it doesn't recognise the test.

=IF(C1="FINISHED","DONE","")

Is there anything I can add to indicate that the cell doesn't need to contain only the exact text "Finished" but so long is it contains that word it should return the value "Done"

Thanks for any help!

Upvotes: 0

Views: 1687

Answers (2)

barry houdini
barry houdini

Reputation: 46401

You can use COUNTIF with wildcards, e.g.

=IF(COUNTIF(C1,"*FINISHED*"),"DONE","")

Upvotes: 1

Dmitry Pavliv
Dmitry Pavliv

Reputation: 35863

Try this one:

=IF(ISNUMBER(SEARCH("FINISHED",C1)),"DONE","")

Upvotes: 2

Related Questions