Kostas,

This formula returns a value of #VALUE!

Let me explain my problem in another way. In Sheet1, there is a list of 5
names.

A2 = Arenas
B2 = Haywood
C2 = Hughes
D2 = Jamison
E2 = Jeffries

In Sheet2, there is a list of 10 names and a letter (A through J) beside
each name. The 5 names in Sheet1 are included in the 10 names in Sheet2.

A3 = Blake B3 = F
A4 = Arenas B4 = B
A5 = Hughes B5 = A
A6 = Dixon B6 = C
A7 = Profit B7 = D
A8 = Peeler B8 = E
A9 = Hayes B9 = G
A10 = Haywood B10 = J
A11 = Jamison B11 = H
A12 = Jeffries B12 = I

I want to determine the smallest letter (A) from Sheet2 and place the
corresponding name (Hughes) in Sheet1 cell F2--only if that name appears on
the list in Sheet1. If not, I want to find the next smallest letter with a
matching name.

Can you help?

Thanks very much,
Bob

"vezerid" wrote:

OK, I had some time and tested this variant, which is correct.

In Sheet1!A7:
=LEFT(INDEX(Sheet2!A2:A6,MATCH(CHAR(MIN(CODE(RIGHT (Sheet2!A2:A6,1)))),RIGHT(Sheet2!A2:A6,1),0)),
FIND("=",INDEX(Sheet2!A2:A6,MATCH(CHAR(MIN(CODE(RI GHT(Sheet2!A2:A6,1)))),RIGHT(Sheet2!A2:A6,1),0)))-2)

HTH
Kostis Vezerides