Hi,
i have a table with some values in a column as follow:
column A | column B
---------------------------
text 1 |
text 2 |
text 3 |

i would like a formula that recognise some key words in column A and return
in column B a value

so for example if text 1 has the word fire detection room A i should have in
column B a text that says fire detector,
if text 1 says gas detector room 2 i would like to have in column B gas
detection and so on.
is there anyone that can help with this please?
thanks in advance