# Index - match

✭✭✭

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?

• Employee

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))

Cheers,

Genevieve

Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now

• Employee

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))

Cheers,

Genevieve

Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!