I want to know how to create a formula that will reference a set of values in
Sheet2 and display the lowest corresponding value in ascending order in
Sheet1.

To be more specific, I have 5 text strings in 5 cells, A2 through A6, in
Sheet1. I want to select the corresponding string in Shee2 and place it in
A7, based on values I have assigned in Sheet2.

Sheet 1:
A2 = Arenas
A3 = Haywood
A4 = Hughes
A5 = Jamison
A6 = Jeffries

Sheet 2:
Arenas = A
Haywood = J
Hughes = B
Jamison = H
Jeffries = I

In Sheet2, the string that corresponds to the lowest letter (Arenas, A) is to
be placed in A7 in Sheet1.

How do I set this up?

Thanks in advance,
Bob