up vote 0 down vote favorite
share [g+] share [fb]

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

Are there functions like these which work for ascending order?

link|improve this question
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
feedback

migrated from stackoverflow.com Apr 10 '11 at 15:24

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

1 Answer

up vote 0 down vote

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)
link|improve this answer
waht you mean??? – Anonymous Apr 10 '11 at 15:21
feedback

Your Answer

 
or
required, but never shown
discard