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