As Seen on TechCrunch: Finofo Raises \$1.65M CAD!

## How to Use XLOOKUP in Excel

The XLOOKUP function in Excel is a powerful tool for looking up and retrieving information from a table or range. Here's a guide on how to use XLOOKUP.

#### Basic Syntax:

=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])

#### Parameters:

• lookup_value: The value you want to find in the lookup_array.
• lookup_array: The range or array containing the values to be searched.
• return_array: The range or array containing the corresponding values to return.
• [if_not_found]: (Optional) The value to return if no match is found. If omitted, it defaults to #N/A.
• [match_mode]: (Optional) The match mode, which can be 0 (exact match, the default), -1 (exact or next smaller item), or 1 (exact or next larger item).
• [search_mode]: (Optional) The search mode, which can be 1 (first-to-last, the default) or -1 (last-to-first).

#### Example:

Assuming you have a table in the range A2:B6 where column A contains names, and column B contains corresponding ages. You want to find the age of a person named "John."

This formula searches for "John" in the names (A2:A6) and returns the corresponding age from column B. If "John" is not found, it returns "Not Found."

#### Tips:

1. Handling Errors:
2. You can use IFERROR to handle potential errors. For example: =IFERROR(XLOOKUP(...), "Not Found").
3. Wildcard Characters:
4. You can use wildcard characters (* and ?) in lookup_value when searching. For example: =XLOOKUP("Joh*", A2:A6, B2:B6).
5. Array Formulas:
6. XLOOKUP can handle arrays as both the lookup_array and return_array, making it versatile for various scenarios.
7. Default Values:
8. If [if_not_found] is omitted, it defaults to #N/A. You can leave it blank or use an empty string if you want a blank cell instead of #N/A.