Google Sheets | XLOOKUP | VLOOKUP | Function | A Key Difference | Example | Spreadsheet | Tutorial

The Google Sheets XLOOKUP and VLOOKUP functions have many key differences. Here is one such difference: XLOOKUP can return a single value or an entire row or column in which the search key is found. VLOOKUP can return only a single value.
For more info on XLOOKUP and VLOOKUP, please refer to their exclusive tutorials whose links are given below.
-------------------------------------
How to Use XLOOKUP to Extract Multiple Values in Google Sheets?
XLOOKUP can return a single row or column with the search key:
• Google Sheets | XLOOKU...
-------------------------------------
How to Use VLOOKUP in Google Sheets?
Use VLOOKUP to get a single value:
• VLOOKUP Google Sheets ...
-------------------------------------
How to Use IFS in Google Sheets?
IFS allow multiple logical expressions:
• Google Sheets IFS | Te...
-------------------------------------
How to Use IF in Google Sheets?
Use IF to compare one value with another:
• Google Sheets IF | Tut...
-------------------------------------
How to Use IF with AND in Google Sheets?
Use IF with AND to Use Multiple Logical Expressions in IF:
• Google Sheets | IF | A...
-------------------------------------
How to Create a Pivot Table in Google Sheets?
Create a pivot table for calculation and in-depth data analysis:
• Google Sheets | Pivot ...
-------------------------------------
Which one to Use? A Pivot Table, or COUNTBLANK Function, to Count Blank Cells in Google Sheets:
Gives steps to use a pivot table or COUNTBLANK to count blank cells:
• Google Sheets | Pivot ...
-------------------------------------
How to Use a Pivot Table to Sum by Rows or Columns without using Formula in Google Sheets?
Sum numbers by rows and or columns easily, using a pivot table:
• Google Sheets | Pivot ...
-------------------------------------
How to Create a Pivot Table to Get Maximum Value without Using Formula in Google Sheets?
A pivot table assists to get the maximum value in a data range without using a formula:
• Google Sheets | Pivot ...
-------------------------------------
The syntax of the XLOOKUP function formula is:
=XLOOKUP(search_key, lookup_range, result_range, [missing_value], [match_mode], [search_mode])
Let's look at an example of XLOOKUP function formula:
Example
=XLOOKUP("Doug", B7:B14, A7:D14, , 2)
search_key is "Doug".
lookup_range, B7 to B14, is the range to lookup for the search key.
result_range is range A7 to D14.
Assume that the search key is found in cell B8. XLOOKUP will return data
in cells A8 to D8.
Here's the syntax of the VLOOKUP function formula:
=VLOOKUP(search_key, range, index, [is_sorted])
Example
=VLOOKUP("Doug",B7:B14,3,0)
search_key in this example also is "Doug".
range is B7 to B14.
index is 3, which means the data in the third cell from the cell with the search key.
is_sorted is 0, which means the data is not sorted.
If search key is found in cell B8, VLOOKUP will return data in cell D8, which is the third cell from B8.
Review this video tutorial, which illustrates a key difference between the Google Sheets XLOOKUP and VLOOKUP functions, with examples.