Statements (31)
| Predicate | Object |
|---|---|
| gptkbp:instanceOf |
Excel function
|
| gptkbp:advantage |
can return entire row or column
can return multiple results can search from first-to-last or last-to-first does not require sorted data |
| gptkbp:availableOn |
gptkb:Excel_for_the_web
gptkb:Excel_for_Mac gptkb:Excel_for_Windows |
| gptkbp:category |
lookup and reference function
|
| gptkbp:compatibleWith |
gptkb:Excel_2010
gptkb:Excel_2013 gptkb:Excel_2016 |
| gptkbp:documentation |
https://support.microsoft.com/en-us/office/xlookup-function-78a5d8fd-5b8a-4c41-8b8a-4de89ab494a8
|
| https://www.w3.org/2000/01/rdf-schema#label |
XLOOKUP
|
| gptkbp:introducedIn |
gptkb:Microsoft_365
gptkb:Microsoft_Excel_2019 |
| gptkbp:replacedBy |
gptkb:HLOOKUP
gptkb:VLOOKUP |
| gptkbp:requires |
lookup_array
lookup_value return_array [if_not_found] [match_mode] [search_mode] |
| gptkbp:result |
corresponding value from another range or array
|
| gptkbp:supports |
horizontal lookup
vertical lookup |
| gptkbp:type |
lookup
|
| gptkbp:usedFor |
searching for a value in a range or array
|
| gptkbp:bfsParent |
gptkb:Microsoft_Excel
|
| gptkbp:bfsLayer |
6
|