Sep 27 2024 02:03 PM - edited Sep 27 2024 02:04 PM
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.
Sep 27 2024 02:14 PM
SolutionSep 27 2024 02:27 PM
Sep 27 2024 02:14 PM
Solution