Use the SMALL function, like this:

INDEX(A8:A34,MATCH(SMALL(G8:G34,2),G8:G34,0))

Change the 2 to 3, 4, 5 etc to get the next smallest.

Hope this helps.

Pete

On Oct 30, 9:00 am, Sean wrote:
The formula below returns the the name associated with the lowest
value in a range. How would I tweak this formula to return the 2nd
lowest value?

INDEX(A8:A34,MATCH(MIN(G8:G34),G8:G34,0))