Changes

where,  

where,  

*<math>lkup_val</math> is the value to be matched from the array

*'''lkup_val''' is the value to be matched from the array

*<math>lkup_arr</math> is the array of values or reference to the cells containing values

*'''lkup_arr''' is the array of values or reference to the cells containing values

*<math>m_type</math> specifies the method for matching the value with values in array. It can be -1, 0 or 1.

*'''m_type''' specifies the method for matching the value with values in array. It can be -1, 0 or 1.

MATCH() displays the relative position of a value in an array that matches a specified value in a specified order.

MATCH() displays the relative position of a value in an array that matches a specified value in a specified order.

*MATCH() displays the relative position of the matched value in an array.

*MATCH() displays the relative position of the matched value in an array.

*<math>lkup_val</math> can be a number, text or logical value, or reference to cells containing number, text or logical value.

*'''lkup_val''' can be a number, text or logical value, or reference to cells containing number, text or logical value.

*<math>lkup_arr</math> can be set of values or a reference to cells containing values.

*'''lkup_arr''' can be set of values or a reference to cells containing values.

*If <math>lkup_val</math> and <math>lkup_arr</math> are text values, they should be entered in quotes (e.g. "JOHN").

*If '''lkup_val''' and '''lkup_arr''' are text values, they should be entered in quotes (e.g. "JOHN").

*The method to find a match can be specified with argument math>m_type</math>. If omitted, Calci assumes it to be '1'.

*The method to find a match can be specified with argument '''m_type'''. If omitted, Calci assumes it to be '1'.

*The following table shows how <math>m_type</math> works with respect to the order of values in Array-

*The following table shows how '''m_type''' works with respect to the order of values in Array-

{| class="wikitable"

{| class="wikitable"

|-

|-

! m_type !! Order of values in Array !!Description

! m_type !! Order of values in Array !!Description

|-

|-

| 1 or omitted || Ascending Order || Finds the largest value &lt;= <math>lkup_val</math>.

| 1 or omitted || Ascending Order || Finds the largest value &lt;= '''lkup_val'''.

|-

|-

| 0 || Any order || Finds the first value exactly equal to <math>lkup_val</math>.

| 0 || Any order || Finds the first value exactly equal to '''lkup_val'''.

|-

|-

| -1 || Descending order || Finds the smallest value &gt;= <math>lkup_val</math>.

| -1 || Descending order || Finds the smallest value &gt;= '''lkup_val'''.

|}

|}

*The uppercase and lowercase characters are not distinguished in an array of text values.

*The uppercase and lowercase characters are not distinguished in an array of text values.