Vlookup Formula Required

[gandhikr]

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

[zbor]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[gandhikr]

Sample Worksheet.xlsx

I have included before & after alongwith a sample data for analisys.

Please provide the required vlookup formula / other formula on urgent basis.

Thanks million for your help..