Find 2nd Smallest Value based on a Cell Reference

[ajw089]

Hello,

I have a list of names that repeat in column A and a list of values in column B, I'm trying to write a formula that will return the 2nd smallest value for each person to be shown in a table. I attempted to use and INDEX MATCH function but I haven't been successful in getting it to work.

Any suggestions?

Thanks!

[JBeaucaire]

It is an array function, you were on the right track, but the function is still SMALL. Enter this array function in F3, then copy down:

=SMALL(IF($A$3:$A$17=E3, $B$3:$B$17), 2)

[ajw089]

This is perfect, thank you!