too many nested ifs

  • G'Day!


    I need to return a name to a cell based on row of cells with changing values -- below is the formula I am trying to use but we have too many if statements. Does anyone have an easier way of doing this?


    Thank you in advance.


    Jason



    =if(C11="Cathe", "Cathe", if(D11="Kevin", "Kevin", if(E11="Casey","Casey", if(F11="Derek","Derek",if(G11="Crystal","Crystal",if(H11="Jason", "Jason", if(I11="Jennifer","Jennifer", "False")))))))

  • Re: too many nested ifs


    Try the following array formula...


    =INDEX(C11:I11,MATCH(TRUE,C11:I11={"Cathe","Kevin","Casey","Derek","Crystal","Jason","Jennifer"},0))


    ...confirmed with CONTROL+SHIFT+ENTER.


    Hope this helps!