Документ взят из кэша поисковой машины. Адрес оригинального документа : http://uneex.mithril.cs.msu.su/static/GnumericDoc_ru/r5978.html
Дата изменения: Mon Sep 26 12:35:55 2011
Дата индексирования: Mon Oct 1 22:49:39 2012
Кодировка: UTF-8
LOOKUP

LOOKUP

Name

LOOKUP -- 

Synopsis

LOOKUP(value,vector1,vector2)

Description

LOOKUP function finds the row index of 'value' in @vector1 and returns the contents of value2 at that row index. If the area is longer than it is wide then the sense of the search is rotated. Alternatively a single array can be used.

If LOOKUP can't find @value it uses the next largest value less than value. The data must be sorted.

If @value is smaller than the first value it returns #N/A

Examples

See also

VLOOKUP, HLOOKUP.