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

Elizabeth Aird

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?

Genevieve P.

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