Hi Experts,

Struggling hard to get below requirement done. Please help. Below is my data

Column A

ABCD PRIVATE LIMITED FED
ABCD PRIVATE LIMITED
PREMIER
ABCD PRIVATE LIMITED LONDEN BRANCH
ABCD INTERNATIONAL FIN
HELLO
ABCD
PQRS

Column B
ABCD
PREMIER

Above being my data in column A and B. I need to search each word in a cell in column A and match to each cell in column B. If any one word matches then i need to print Value of the cell in column A in column C

Below is output required

Column C
ABCD PRIVATE LIMITED FED
ABCD PRIVATE LIMITED
PREMIER
ABCD PRIVATE LIMITED LONDEN BRANCH
ABCD INTERNATIONAL FIN
N/A
ABCD
N/A