The XLOOKUP Function in Excel Easily Explained!

You shouldn't limit yourself to a world with VLOOKUP. I love VLOOKUP, but the XLOOKUP function in Excel will give you more power and flexibility that other lookup formulas can't.

In six minutes, I'll show you how easy it is to use XLOOKUP to expand your skillset and save time you shouldn't have to waste!

00:00 Why you should use XLOOKUP instead
00:20 XLOOKUP syntax example
01:01 Exact match options
01:36 Search with multiple criteria
02:35 How to handle no matches
03:09 XLOOKUP beginning at bottom of list
03:22 XLOOKUP with a wildcard
04:41 Return an array and transpose
05:14 Multiple criteria with nested horizontal XLOOKUP
06:18 Outro

Looking for more Excel help? ➡️ https://sheetskunk.com

Let's connect on social! 👨‍💻📲

TikTok ➡️ https://www.tiktok.com/@sheetskunk
Instagram ➡️ https://www.instagram.com/sheetskunk/
Pinterest ➡️ https://www.pinterest.com/sheetskunk/

Видео The XLOOKUP Function in Excel Easily Explained! канала Sheet Skunk