Statements (31)
| Predicate | Object |
|---|---|
| gptkbp:instanceOf |
Excel function
|
| gptkbp:availableOn |
gptkb:Excel_for_the_web
gptkb:Excel_for_Mac gptkb:Excel_for_Windows |
| gptkbp:category |
gptkb:Lookup_&_Reference
|
| gptkbp:compatibleWith |
gptkb:Excel_2010
gptkb:Excel_2013 gptkb:Excel_2016 |
| gptkbp:defaultMatchMode |
exact match
|
| gptkbp:hasSyntax |
=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])
|
| https://www.w3.org/2000/01/rdf-schema#label |
XLOOKUP function
|
| gptkbp:introducedIn |
gptkb:Microsoft_365
gptkb:Microsoft_Excel_2019 |
| gptkbp:purpose |
lookup values in a range or array
|
| gptkbp:replacedBy |
HLOOKUP function
VLOOKUP function |
| gptkbp:requires |
if_not_found
lookup_array lookup_value match_mode return_array search_mode |
| gptkbp:result |
single value
array of values default value if not found |
| gptkbp:searchableBy |
from first to last
from last to first |
| gptkbp:supports |
horizontal lookup
vertical lookup |
| gptkbp:bfsParent |
gptkb:Excel
|
| gptkbp:bfsLayer |
5
|