|
Документ взят из кэша поисковой машины. Адрес
оригинального документа
: http://uneex.lorien.cs.msu.su/static/GnumericDoc_ru/r6021.html
Дата изменения: Mon Sep 26 12:35:55 2011 Дата индексирования: Tue Oct 2 07:48:00 2012 Кодировка: UTF-8 |
MATCH function finds the row index of @seek in @vector and returns it. If the area is longer than it is wide then the sense of the search is rotated. Alternatively a single array can be used.
The @type parameter, which defaults to +1, controls the search:
If @type = 1, finds largest value <= @seek.
If @type = 0, finds first value == @seek.
If @type = -1, finds smallest value >= @seek.
For type 0, the data can be in any order. For types -1 and +1, the data must be sorted. (And in this case, MATCH uses a binary search to locate the index.)
If @seek could not be found, #N/A is returned.