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

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

1 Answer 1

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.