Index - match

Onlylonely

Hi All,

I've been trying to get the Name A, and the minimum scoring is 3.

=INDEX(C2:C11,MATCH(1,(A:A=B13)*MIN(C2:C11),0))

= 2

Anyone can help on the formula?

Genevieve P.

Hi @Onlylonely

What I would do in Smartsheet is set up a second sheet (or you could use two columns in the current sheet), listing all the names down one column. In my example I'll title the column "Name".

Then you can use an MIN(COLLECT( in the second column to look at that name and check your other grid to pull back the MIN, like so:

=MIN(COLLECT({Scoring Column other sheet}, {Name Column other sheet}, Name@row))

If you're putting this formula in the same sheet, the column references would look like this:

=MIN(COLLECT(Scoring:Scoring, Name:Name, Name@row))

See: MIN Function, COLLECT Function, Formulas: Reference data from other sheets, Create a Cell or Column Reference in a Formula

Cheers,

Genevieve

Genevieve P.

Hi @Onlylonely

What I would do in Smartsheet is set up a second sheet (or you could use two columns in the current sheet), listing all the names down one column. In my example I'll title the column "Name".

Then you can use an MIN(COLLECT( in the second column to look at that name and check your other grid to pull back the MIN, like so:

=MIN(COLLECT({Scoring Column other sheet}, {Name Column other sheet}, Name@row))

If you're putting this formula in the same sheet, the column references would look like this:

=MIN(COLLECT(Scoring:Scoring, Name:Name, Name@row))

See: MIN Function, COLLECT Function, Formulas: Reference data from other sheets, Create a Cell or Column Reference in a Formula

Cheers,

Genevieve