12/20/2023 0 Comments Librecalc![]() ![]() If Type is non-numeric, then MATCH reports a #VALUE! error.If Lookup array is a multi-dimensional cell range, then MATCH reports a parameter list error (Err:504).MATCH returns the position of the smallest value in Lookup array that is greater than or equal to Search criterion. ![]() Lookup array is assumed to be sorted in descending order. Search criterion can optionally utilize either regular expressions or wildcards, if these are enabled. MATCH returns the position of the first exact match. Lookup array is not assumed to be sorted in any particular way. ![]() ![]() MATCH returns the position of the largest value in Lookup array that is less than or equal to Search criterion. (default) Lookup array is assumed to be sorted in ascending order (see the #Additional details: section below for a description of the sorting order). The intended values for Type are as follows: Type is an integer, or a reference to a cell containing an integer, that indicates in which sorting order the data in Lookup array will be searched-for. 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. Search criterion is matched against the contents of cells in Lookup array. Search criterion is either 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. The matching process can also utilize either wildcards or regular expressions.īy default, the matching is not case-sensitive, but a case-sensitive match can be carried out when using a regular expression. Identifies the relative position of a search item in a single-row or single-column cell range, depending on its arguments. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |