How to Use XLOOKUP in Google Sheets

The XLOOKUP function is the most powerful and flexible spreadsheet lookup function. In this tutorial, you’ll learn how to use the XLOOKUP function in Google Sheets with 7 examples, from simple to complex. We’ll look at how to return values to the left of the search column, how to do approximate matching, how to use the built-in error handling, do wildcard matching, and much more.

📚 Additional resources:
1. Template to follow along: https://docs.google.com/spreadsheets/...
2. XLOOKUP written tutorial: https://www.benlcollins.com/spreadshe...

📖 Chapters:
0:00 - Introduction
0:43 - Example 1: Basic XLOOKUP
2:43 - Example 2: Error handling
4:15 - Example 3: Lookup to the left
4:57 - Example 4: Approximate matching
7:21 - Example 5: Wildcard matching
10:58 - Example 6: Returning multiple results
11:45 - Example 7: Search options (top to bottom or bottom to top)

✉️ Google Sheets Tips Newsletter, my free weekly newsletter:
https://www.benlcollins.com/google-sh...

#googlesheets #googlesheetstutorial #spreadsheet