# Manuals/calci/MATCH

MATCH (Value,Array,Type)

where,

• Value is the value to be matched from the array
• Array is the array of values or reference to the cells containing values
• Type specifies the method for matching the value with values in array. It can be -1, 0 or 1.
• MATCH(), looks up values in a reference or array.

## Description

MATCH (Value,Array,Type) e.g. MATCH("A",["A","B","C"],1) returns relative position of 'A' as 1.

MATCH(44,[40,42,44],1) returns relative position of '44' as 3.

• MATCH() displays the relative position of the matched value in an array.
• Value can be a number, text or logical value, or reference to cells containing number, text or logical value.
• Array can be set of values or a reference to cells containing values.
• If Value and Array are text values, they should be entered in quotes (e.g. "JOHN").
• The method to find a match can be specified with argument Type. If omitted, Calci assumes it to be '1'.
• The following table shows how Type works with respect to the order of values in Array-
Type Order of values in Array Description
1 or omitted Ascending Order Finds the largest value <= Value.
0 Any order Finds the first value exactly equal to Value.
-1 Descending order Finds the smallest value >= Value.
• The uppercase and lowercase characters are not distinguished in an array of text values.
• If no matching value is found, Calci displays #NULL error message.
• For invalid arguments, Calci displays #NULL error message.

## Examples

 34 JOHN 45 46 SMITH 12 51 MARY 3 75 1
```=MATCH(46,A1:A4,1) : Matches value '46' with that in an array with reference cells A1 to A4. Returns the relative position 2.
=MATCH(39,A1:A4,1) : As no exact match, Calci finds largest number in array that is less than '39'. Returns the relative position 1 for value '34'.
=MATCH("MARY",B1:B3,0) : Matches string 'MARY' with that in an array with reference cells B1 to B3. Returns the relative position 3.
=MATCH(45,C1:C4,-1) : Matches value '45' with that in an array with reference cells C1 to C4. Returns the relative position 1.
=MATCH(2,C1:C4,-1) : As no exact match, Calci finds smallest number in array that is greater than '2'. Returns the relative position 3 for value '3'.
```

MATCH