Statements (43)
| Predicate | Object |
|---|---|
| gptkbp:instanceOf |
Excel function
lookup function |
| gptkbp:availableOn |
gptkb:Excel_for_the_web
gptkb:Excel_for_Mac gptkb:Excel_for_Microsoft_365 gptkb:Excel_for_Android Excel for iPad |
| gptkbp:canBe |
dynamic arrays
|
| gptkbp:category |
lookup and reference
|
| gptkbp:compatibleWith |
gptkb:Excel_2010
gptkb:Excel_2013 gptkb:Excel_2016 |
| gptkbp:documentation |
https://support.microsoft.com/en-us/office/xmatch-function-d966da31-7a6b-4a13-a1c6-5a33ed6a0312
|
| gptkbp:hasSyntax |
XMATCH(lookup_value, lookup_array, [match_mode], [search_mode])
|
| https://www.w3.org/2000/01/rdf-schema#label |
XMATCH function
|
| gptkbp:introducedIn |
gptkb:Microsoft_Excel_2019
Microsoft Excel 365 |
| gptkbp:match_mode_-1 |
exact match or next smallest
|
| gptkbp:match_mode_0 |
exact match (default)
|
| gptkbp:match_mode_1 |
exact match or next largest
|
| gptkbp:match_mode_2 |
wildcard match
|
| gptkbp:purpose |
returns the relative position of an item in an array or range
|
| gptkbp:relatedTo |
gptkb:XLOOKUP_function
HLOOKUP function VLOOKUP function MATCH function |
| gptkbp:replacedBy |
MATCH function
|
| gptkbp:requires |
lookup_array
lookup_value [match_mode] [search_mode] |
| gptkbp:result |
#N/A error if not found
position as a number |
| gptkbp:search_mode_-1 |
search from last to first
|
| gptkbp:search_mode_-2 |
binary search descending
|
| gptkbp:search_mode_1 |
search from first to last (default)
|
| gptkbp:search_mode_2 |
binary search ascending
|
| gptkbp:supports |
wildcard matching
horizontal lookup vertical lookup reverse search |
| gptkbp:bfsParent |
gptkb:Microsoft_Excel_2021
|
| gptkbp:bfsLayer |
6
|