Forum Discussion

Lgibson500's avatar
Lgibson500
Copper Contributor
Feb 21, 2020
Solved

IFS formula returning #NAME?

Why would this formula be returning #NAME? IFS(AND(E6="Rare",F6="Low"),"Minimal",AND(E6="Rare",F6="Moderate"),"Minimal",AND(E6="Rare",F6="Critical"),"Minimal",AND(E6="Rare",F6="Catastrophic"),"Moder...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Feb 21, 2020

    Lgibson500 

    For such sample

    formula in G6 is

    =IFNA(INDEX($J$5:$M$7,MATCH($F6,$I$5:$I$7,0),MATCH($E6,$J$4:$M$4,0)),"wrong data")

    Matrix itself could be at any place, better in another sheet. And better to use named ranges for it.

ExcelExciting's avatar
ExcelExciting
MVP
Feb 21, 2020

HI Lgibson500,

 

What is the version of your Excel IFS Function ?

IFS function support only Excel Office 365 (Mac & Windows), Excel 2019 (Mac & Windows) & Excel Online.

 

Regards, Faraz Shaikh

Resources