XLOOKUP function

GPTKB entity

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