Statements (50)
| Predicate | Object |
|---|---|
| gptkbp:instance_of |
gptkb:Mathematics
|
| gptkbp:array_size |
Can handle arrays of different sizes.
|
| gptkbp:community_support |
Active user community for tips.
|
| gptkbp:compatibility |
Only available in Excel 365 and Excel 2021.
|
| gptkbp:data_type |
Works with text, numbers, and dates.
|
| gptkbp:default_match_mode |
Exact match.
|
| gptkbp:default_search_mode |
First-to-last.
|
| gptkbp:description |
A function that searches a range or an array and returns an item corresponding to the first match.
|
| gptkbp:error_handling |
Can return a custom message if not found.
|
| gptkbp:error_message |
# N/ A if no match is found.
# VALUE! if the arrays are not the same size. |
| gptkbp:excel_version |
Part of Microsoft 365 subscription.
|
| gptkbp:formula_examples |
= XLOOKUP(A1, B1: B10, C1: C10, , 0) for exact match.
= XLOOKUP(A1, B1: B10, C1: C10, , 1) for approximate match. = XLOOKUP(A1, B1: B10, C1: C10, , , -1) for reverse search. = XLOOKUP(A1, B1: B10, C1: C10, " Not Found") returns custom message. = XLOOKUP(A1, B1: B10, C1: C10) returns corresponding value. |
| gptkbp:formulation |
XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])
|
| gptkbp:has_documentation |
Available on Microsoft support site.
|
| gptkbp:has_limitations |
Not available in older versions of Excel.
|
| https://www.w3.org/2000/01/rdf-schema#label |
XLOOKUP
|
| gptkbp:if_not_found |
Optional value to return if no match is found.
|
| gptkbp:introduced_in |
gptkb:Excel_365
|
| gptkbp:is_opposed_by |
INDEX-MATCH combination.
LOOKUP function. |
| gptkbp:lookup_array |
The array or range to search.
|
| gptkbp:lookup_value |
The value to search for.
|
| gptkbp:match_mode |
Specifies how to match the lookup value.
|
| gptkbp:performance |
Faster than VLOOKUP for large datasets.
|
| gptkbp:related_functions |
INDEX
MATCH FILTER |
| gptkbp:replaces |
VLOOKUP
HLOOKUP |
| gptkbp:return_array |
The array or range to return values from.
|
| gptkbp:search_mode |
Specifies the search direction.
|
| gptkbp:supports |
Exact match search.
Wildcard match search. Return multiple values. Search from last to first. |
| gptkbp:tutorials |
Numerous online tutorials available.
|
| gptkbp:use_case |
Data validation.
Dynamic data retrieval. Finding values in large datasets. Replacing nested IF statements. Creating dashboards. |
| gptkbp:user_feedback |
Highly rated for ease of use.
|
| gptkbp:user_interface |
Available in the formula bar.
|
| gptkbp:bfsParent |
gptkb:Microsoft_Excel_for_Windows
|
| gptkbp:bfsLayer |
6
|