I have a very long spreadsheet that has a column with different tactics in it. I want to create a formula to look at a specfic column (column H) in the spreadsheet and tell me if the word "cloud" or "virtualization" is present anywhere in that cell. So if cloud is in h3 then put the word cloud in column i. If virtualization is anywhere in column H, then put virtualization in column i.
Is there a formula that can do both cloud and virtualization in 1 formula?
Any help would be much appreciated!
Bookmarks