How can I assign a value to cells if it's neighbour contains a specific string?
For example, fields in column A:
dog11
cat22
cow11
chick11
duck22
cat11
horse22
cat33
The syntax in column B would be:
=IF(SEARCH("cat",A1),"cat",IF(SEARCH("22",A1),"22","none"))
It always picks up the first TRUE cell, but drops when the value is not true.