Forum Discussion

g_pramono's avatar
g_pramono
Copper Contributor
Apr 01, 2026
Solved

Finding return value from multiple columns/cells with specific text

Hello, I have to verify multiple cells (C2 to F2) with two possible statuses: "Eligible" and "Not Eligible". In Excel, would it be possible to: If all cells "Eligible", then the result is "Passed"...
excel
Formulas and Functions
office 365
  • m_tarler's avatar
    m_tarler
    Apr 02, 2026

    yes,  try this:

    =IFS(AND(D3:G3="Eligible"),"Passed",OR(D3:G3="Consult"),"No Result",OR(D3:G3="Not Eligible"),"Failed",1,"Error")

    here is the result:

    I will try to attach the file...

IlirU's avatar
IlirU
Iron Contributor
Apr 03, 2026

Hi g_pramono​,

Apply below formula in cell G2:

=LET(
     doc, C2:F5,
          IF(BYROW(doc = "Consult", OR), "No Result",
          IF(BYROW(doc = "Eligible", AND), "Passed", "Failed"))
)

Hope this helps.

IlirU