You said before:

If any one word matches then i need to print Value of the cell in column A in column C
which is what the formula seems to be doing. Are you now saying that you want the matching word (from column B) to appear in column C ?

Pete