Teach me how to excel match next largest value?

Asked By Timothy Raine 40 points N/A Posted on - 02/13/2013

Good Evening Everyone,

How can I use Match() function in Microsoft excel 2007 to find the next largest value.

Please give me a tutorial which explains me clearly how to find next highest value.

Also tell me when using match function, data needs to be in which order (descending or ascending)?

Please provide me the best tutorial or article for Excel match next largest value.

I would appreciate your help.

Thanks.

• Status: Open
• Question Views: 743
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Munguia Roya 0 points N/A #185047

Teach me how to excel match next largest value?

Hi Timothy,

 

The MATCH() Function returns the Position of the Specified Value in the array or a range of cells.

 

The syntax is: = MATCH (Lookup_value, Lookup_array, Match_type)

 

Lookup_Value: The Value you want to find, Required.

Lookup_Array: Range of cells to be searched, Required.

Match_Type: How to match the Lookup_value, Optional.

= 1 or Omitted, finds the largest value that is less than or equal to the lookup value, the lookup_array been sorted in ascending order.

= 0, finds the first value that is an exact match to lookup_value

= -1, finds the smallest value that is greater than or equal to the lookup_value, the lookup_array been sorted in descending order.

 

For Example,

 

If from A1 to A7, we have 35, 28, 25, 24, 19, 10, 7 arranged in Descending Order then.

 

= MATCH(30, A1:A7, -1) returns 28, the next largest value to 30 which is present in the data range.

 

Hope this Helps.

About Munguia Roya

Questions
2

Answers
12

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 02/20/2013
• Question Category: MS Excel