OOPS, you said 2nd smallest so substitute Small for large


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