Search Mode: (optional) specifies the search mode to use.
1: returns the first occurrence starting from the first item of Search Array (default).
-1: reverse search. Returns the first occurrence starting from the last item of Search Array.
2: binary search that relies on Search Array being sorted in ascending order. If not sorted, invalid results will be returned.
-2: binary search that relies on Search Array being sorted in descending order. If not sorted, invalid results will be returned.
Match Mode values 2 and 3 cannot be combined with binary search (Search Mode value 2 or -2).
Any of the optional arguments can be omitted. An optional argument requires all preceding separators to be present.
ምሳሌዎች
Suppose we have built a small database table occupying the cell range A1:DO4 and containing basic information about 118 chemical elements. The first column contains the row headings “Element”, “Symbol”, “Atomic Number”, and “Relative Atomic Mass”. Subsequent columns contain the relevant information for each of the elements, ordered left to right by atomic number. For example, cells B1:B4 contain “Hydrogen”, “H”, “1” and “1.008”, while cells DO1:DO4 contain “Oganesson”, “Og”, “118”, and “294”.
A
B
C
D
...
DO
1
አካል
Hydrogen
Helium
Lithium
...
Oganesson
2
ምልክት
H
He
Li
...
Og
3
Atomic Number
1
2
3
...
118
4
Relative Atomic Mass
1.008
4.0026
6.94
...
294
=XMATCH("Atomic Number"; A1:A4) returns 3, the third line of the A1:A4 array.
=XMATCH("Li"; A2:DO2) returns 4, the fourth column of the A2:DO2 array.
Technical information
This function is available since LibreOffice 24.8.
This function is not part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is