In this case, Lookup array is assumed to be sorted in ascending order (see the #Additional details: section below for a description of the sort order). The intended values for Type are as follows: Type is an integer, or a reference to a cell containing an integer, that indicates how the data in Lookup array is organized. It may also be specified using the name of a named range or a database range, or may be passed as an inline array. Lookup array is the single row or single column range of cells to be searched, typically defined by entering the cell reference for the upper left-hand cell, followed by a colon (:), and then the lower right-hand cell reference (for example, A1:E1 or B1:B7). Search criterion is matched against the contents of cells in Lookup array. Search criterion is a text string (in quotation marks), a number, a Boolean, or a reference to a cell containing one of those types. ![]() Returns an integer ranging from 1 to the size of the specified lookup array, giving the position of the searched for item in the given range of cells. ![]() By default, the matching is not case-sensitive, but a case-sensitive match can be carried out when using a regular expression. The matching process can utilize either wildcards or regular expressions. Determines the position of a search item in a single row or single column cell range.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |