I’m trying to sort through a column of remarks. If any of the remarks contain one word, I need to pull that word out. If it says a different word, I need to pull that one out. No remark should have both, but some will have neither. If there is neither, it can be left blank. 
I’ve tried to use
=IF((FIND(“FWA”,DATA!AM7)), “FWA”,
IF(FIND(“JBER”,DATA!AM7),”JBER”))

which will work for the first value, but for the second I get a “#VALUE!” error. 

What am I doing wrong here? As far as I can tell the syntax is legit. 

​I’m trying to sort through a column of remarks. If any of the remarks contain one word, I need to pull that word out. If it says a different word, I need to pull that one out. No remark should have both, but some will have neither. If there is neither, it can be left blank. I’ve tried to use=IF((FIND(“FWA”,DATA!AM7)), “FWA”,IF(FIND(“JBER”,DATA!AM7),”JBER”))which will work for the first value, but for the second I get a “#VALUE!” error. What am I doing wrong here? As far as I can tell the syntax is legit.   Read More

​