Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In Excel, the functions lookup and match are for descending order.

Are there functions like these which work for ascending order?

share|improve this question

migrated from Apr 10 '11 at 15:24

This question came from our site for professional and enthusiast programmers.

Match does ascending and descending, as well as exact match for unsorted lists. Look in help for the details. – Doug Glancy Apr 10 '11 at 15:56

While lookup works for ordered lists only, MATCH does not need this if the match_type (3rd arg) is set to zero.

= MATCH(value, list, 0)
share|improve this answer
waht you mean??? – Anonymous Apr 10 '11 at 15:21

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.