Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Jason Perry   on Nov 28 In MS Office Category.

  
Question Answered By: Pam Harrison   on Nov 28

Help on the match  function says it has a third parameter match_type
which is assumed to be 1 if it is missing. This looks up the item or
the next larger one, but requires the array to be in order.

You could sort your array and it will probably work, or you could use
MATCH(PI,Months,0).

Share: 

 

This Question has 3 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on 2003 Match() Problem Or get search suggestion and latest updates.


Tagged: