XLOOKUP Google Sheets: How to Use XLOOKUP in Google Sheets (New in 2022)

The time has come, XLOOKUP Google Sheets is finally available. In this video, we'll show you the many flexible ways XLOOKUP can be used and how it can replace VLOOKUP, providing much faster formula build and easier formula keys.

Video Timeline
00:00: Introduction
00:26: How to Use XLOOKUP
00:45: Lookup Range in XLOOKUP
01:31: VLOOKUP vs XLOOKUP
02:20: Missing Value in XLOOKUP
03:47: XLOOKUP in Another Tab
04:25: XLOOKUP in Another Spreadsheet
06:20: Match Mode in XLOOKUP
08:45: Return Multiple Columns with XLOOKUP
09:55: Horizontal Matching with XLOOKUP

Any questions? Comment below; we have Google Sheets experts on the other side.

#googlesheets #googlesheetstutorial #xlookup #coefficient