Searching a keyword in excel


I have one excel file with keywords(column A) and email(column B). Also I have other excel file with two columns.

I need search the other excel (column A) with keywords from first excel and then copy that row and send mail which is in the some row es correct keyword from first excel.

My keyword(first excel) is error then I need to go in other excel and in the first column I need find all row with that word and then I need a copy that row and send on the email address(first excel) which is in the some row like a keyword.

Is someone have solution how can i do that?

@JOHOHO Can you provide the two Input Files and the Expected Output File? It will be easier to solve that way :sweat_smile: