Alphabetizing question

**aresquare1** · 04-10-2013, 07:31 AM

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

**Pepe Le Mokko** · 04-10-2013, 07:32 AM

VLOOKUP does not need any kind of order providing you use the FALSE switch

**aresquare1** · 04-10-2013, 07:43 AM

PERFECT.

Thanks
RR

**arlu1201** · 04-10-2013, 08:17 AM

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.