Take the 2-minute tour ×
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 stackoverflow.com 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
add comment

1 Answer

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
add comment

Your Answer

 
discard

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