Related Topics:

Spreadsheet Mathematical Functions

Function Wizard Functions

MATCH

Description: Returns the relative position of an item in an array that matches a specified value and order. Use MATCH instead of one of the LOOKUP functions when you need the position of an item in a range instead of the item itself.

Syntax: MATCH(Lookup_value, Lookup_array, [Match_type])

Lookup_value is the value you want to match in Lookup_array. For example, when you look up someone's number in a telephone book, you are using the person's name as the lookup value, but the telephone number is the value you want.

Lookup_value can be a value (number, text, or logical value) or a cell reference to a number, text or logical value.

If Match_type is 1, MATCH finds the largest value that is less than or equal to Lookup_value. Lookup_array must be placed in ascending order: ...-2, -1, 0, 1, 2, ..., A-Z, FALSE, TRUE.

If Match_type is 0, MATCH finds the first value that is exactly equal to Lookup_value. Lookup_array can be in any order.

If Match_type is -1, MATCH finds the smallest value that is greater than or equal to Lookup_value. Lookup_array must be placed in descending order: TRUE, FALSE, Z-A,...2, 1, 0, -1, -2,..., and so on.

If Match_type is omitted, it is assumed to be 1.

Remarks:

Example:

Suppose A2:A5 contain "Bananas", "Oranges", "Apples", "Pears", respectively. B2:B5 contain "25", "38", "40", "41", respectively.

 

© 1992-2013. ReliaSoft Corporation. ALL RIGHTS RESERVED.