Hello,

I have below data in Excel with 4 columns:

Row Labels Sum of Impressions Sum of Clicks Sum of Spend
2014 webroot 1 0 0
activate webroot 4 0 0
activate webroot key code 3 0 0
activate webroot secureanywhere 2 0 0
activate webroot software 1 0 0
activate webroot subscription 2 0 0
activate webroot with keycode on new pc 1 0 0
add a computer to my webroot accountwebroot 1 0 0

I have another column which has some other keywords such as:
activate
remove
delete
install
setup
set up
buy

I want a Excel formula which should search data in Raw Label column (A). If it finds any of the word in the cell, it should write that word in adjacent cell.

The output should be as under:
Row Labels Column2 Sum of Impressions Sum of Clicks Sum of Spend
2014 webroot 0 1 0 0
activate webroot activate 4 0 0
activate webroot key code activate 3 0 0
activate webroot secureanywhere activate 2 0 0
activate webroot software activate 1 0 0
activate webroot subscription activate 2 0 0
activate webroot with keycode on new pc activate 1 0 0
add a computer to my webroot accountwebroot 0 1 0 0

Note: If more then one words are found the column 2 should have both the word separated by -

Pls help