How to add iferror to formula

Dear all

i have an excel database which search for a word in a cell and if it finds it, it puts it in another cell. The problem is the sell contains #N/A until it finds a word to be replaced. I was wondering if there is a possibility to add iferror to the formula in order to show the cell empty inested of showing #N/A?

i am really looking for your support and help as this is the best site to place a question

Thank you in advance.