I have a matrix contain employee names. Is there a way to return the text with a formula the name of the employee that would be first in the alphabet, then second, then so on. My problem is that I need information for employees on one sheet obtained from this other employee matrix. I believe that a VLOOKUP will only work if the reference matrix is in numberical or alphabetical order. In other words, I need to alphabetize a matrix without having to sort it everytime. Example

Sheet1:
Bill 36,000
Tom 58,000
Aaron 45,000

Sheet2:

What is the amount for Aaron?

Thanks for your help.
RR