XMATCH

Searches for a value in an array or range of cells and returns the relative position of the item.

Syntaks

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.

MatchType: Specify the match type:

SearchMode: Specify the search mode to use:

note

XMATCH outperforms function MATCH as it allows searches according to the search mode.


Eksempler

The table below contains a glossary for translators:

A

B

C

D

1

English

French

Italian

Japanese

2

New

Nouveau

Nuovo

新しい

3

Save

Enregistrer

Salva

保存

4

Open

Ouvrir

Apri

開ける


=XMATCH("Save", A2:A4, 0, 1) returns 2, the second line of the A2:A4 range.

Tekniske oplysninger

tip

This function is available since LibreOfficeDev 24.8.


Denne funktion er ikke en del af standarden Open Document Format for kontorprogrammer (OpenDocument) Version 1.3. del 4: Omregnet formel (OpenFormula) -format. Navnerummet er

COM.MICROSOFT.XMATCH