LibreOfficeDev 24.8 Hjälp
Searches for a value in an array or range of cells and returns the relative position of the item.
XMATCH(Lookup; Array [; MatchType; SearchMode ] )
Lookup: The value of any type to search for in Array.
Array: is the reference of the array or range to search.
XMATCH outperforms function MATCH as it allows searches according to the search mode.
=XMATCH("Save", A2:A4, 0, 1) returns 2, the second line of the A2:A4 range.
COM.MICROSOFT.XMATCH