Returns the relative position of an item in an array that matches a specified value in a specified order.
Name | Type | Description |
arg1 | any | Is the value you use to find the value you want in the array, a number, text, or logical value, or a reference to one of these. |
arg2 | number | Is a contiguous range of cells containing possible lookup values, an array of values, or a reference to an array. |
arg3 | number | Is a number 1, 0, or -1 indicating which value to return.. |