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.


    =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...


    ...confirmed with CONTROL+SHIFT+ENTER.

    Hope this helps!