Column A Column D
Dog animals are nice Nice
cat animals are nice Nice
sheep not nice Not nice
Imagine I have this excel sheet and have Column D which is a drop down list that allows me to choose within its range; however, this example contains only two possible entries nice and not nice.
There is a formula =IF(ISERROR(SEARCH("*nice*",A:A,1)),"","A") that allows me to search in A and if there is a nice word it reflects it into D. is it possible to have the same function working in D despite of the fact it is a drop down list. Because it gives me an error saying restricted values can be entered into cell.
And how can I upgrade the search and place formula to look for more than one possible answer. For example search for nice, not nice, in between and more possible words.