Will it be only single words in the cells?

If not:

=IF(COUNTIF(H:H,"*cloud*"),"cloud",IF(COUNTIF(H:H,"*visualization*"),"visualization",""))

If so, then remove the *'s