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?
Bookmarks