Thread: Using an if statement to pull data from other cells if a certain word is used

Ok, so here's what I'm trying to do. So if a cell contains a certain word (say TCA), I want that cell to be inserted. If the cell does not contain TCA, I want the cell to be blank or 0.

Here's the formula I've come up with so far: =IF(SEARCH("TCA",C10),C10) it works, but for the cells that don't contain DOG, they say #VALUE!
It looks like this:

TCA -> TCA
ACT -> #VALUE!
CAT -> #VALUE!
TCA -> TCA

I've attached the excel file in case anyone would like to give a whirl. I just need the #VALUE! error to be blank or a 0, but I can't find any way to do this. Any suggestions?

Try
=IF(ISERROR(SEARCH("TCA",A8)),"",A8)