Google Sheets | XLOOKUP | Function | Exact | Approximate | Match | Example | Spreadsheet | Tutorial
The Google Sheets powerful and versatile XLOOKUP function can do an approximate match, if it cannot do an exact match. Let's consider an example. Say you want to award certain percent of scholarship to students based on their total score in three subjects. An approximate match too assists to award scholarship, if there is not an exact match of the total score.
What's more, XLOOKUP allows to match a value that is higher or lower than a reference value.
For an intro to XLOOKUP, please refer to its exclusive tutorial titled How to Use XLOOKUP in Google Sheets whose link is given in the description.
*************************************
How to Use XLOOKUP to Extract Multiple Values in Google Sheets?
XLOOKUP is a superb function to extract data or assign values:
• Google Sheets | XLOOKUP | Function | ...
*************************************
-------------------------------------
How to Use VLOOKUP in Google Sheets?
Use VLOOKUP to extract a single value:
• VLOOKUP Google Sheets | How to Use VL...
-------------------------------------
How to Create a Pivot Table in Google Sheets?
Create a pivot table for calculation and in-depth data analysis:
• Google Sheets | Pivot Table | How to ...
-------------------------------------
How to Use Convert to Table in Google Sheets?
Convert a data range into a table easily:
• Google Sheets | Convert to Table | Ch...
-------------------------------------
How to Use SCAN in Google Sheets?
It's easy to calculate running total, running count and the like with SCAN:
• Google Sheets | SCAN | Function | Cal...
-------------------------------------
How to Use FREQUENCY in Google Sheets?
FREQUENCY returns the frequency distribution of data:
• Google Sheets | FREQUENCY | Function ...
-------------------------------------
How to Use COUNTIFS in Google Sheets?
Count values that fulfill one or more criteria:
• How to use COUNTIFS in Google Sheets ...
-------------------------------------
Let's take a look at the syntax of the XLOOKUP function formula:
=XLOOKUP(search_key, lookup_range, result_range, [missing_value], [match_mode], [search_mode])
The first three arguments are only mandatory. However, the optional attributes make XLOOKUP versatile. These can be used based on the task on hand.
Review this video tutorial, which explains and illustrates the Google Sheets XLOOKUP function argument that assists in conducting exact and approximate matches, with real-world examples.