Not accurate. Below is the result.

Column C

IFIC BANK LIMITED FEDERATION
n/a
PREMIER
IFIC BANK LIMITED MOTIJHEEL BRANCH
IFIC INTERNATIONAL FINANCE
IFIC
ICICI


The formula =IF(OR(ISNUMBER(SEARCH(B1,A1)),ISNUMBER(SEARCH(B2,A1))),A1,"n/a") is searching the word from Column B against Column A. I think i my case; i need to take each word in A1 and search for the word in Column B if any one word matches the i need to print the same in Column C.

Please correct if my explanation is wrong