Index/Match to look at numeric value (3 columns) to output

I need a formula that will look at 3 different columns and give the output (AP).


I have a sheet set up for inputs to these same column headers. How do I set this up?




Answers

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Elizabeth Aird

    An Index(Match with multiple criteria/columns is an INDEX(COLLECT.

    First you list the range/column you want the bring the value back from. Then you list each column in a cross-sheet reference and after it the criteria. It sounds like you have the exact same column names set up in this second sheet, so try something like this:

    =INDEX(COLLECT({Action Priority}, {Severity}, Severity@row, {Occurrence}, Occurrence@row, {Detection}, Detection@row), 1)


    Cheers,

    Genevieve

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!