Forum Discussion

GlintF's avatar
GlintF
Copper Contributor
Sep 27, 2024

Getting an error when using nested IF function

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 b...
  • m_tarler's avatar
    Sep 27, 2024
    The problem is that FIND() will return #VALUE! if not found. So enclose that in ISNUMBER() or IFERROR( ... , 0) like:
    =IF(ISNUMBER(FIND("FWA",DATA!AM7)), "FWA", IF( ISNUMBER(FIND("JBER",DATA!AM7)),"JBER",""))
    and I added a "" if not found

Resources