Top 6 reasons why XLOOKUP is better than VLOOKUP in Microsoft Excel




About this tutorial:

Video duration: 00:15:28
In this Excel Formula & Functions tutorial you are going to learn the top 6 reasons why XLOOKUP is better than VLOOKUP in Microsoft Excel!

This Excel Formula & Functions tutorial was recorded using Microsoft Office 365.

📥 Download this workbook so you can practice along with us:

⌚ Time Stamps:
00:00 – Introduction
00:20 – XLOOKUP advantages over VLOOKUP, HLOOKUP & INDEX/MATCH
01:08 – XLOOKUP EXACT MATCH to the left or right
05:11 – XLOOKUP “IF NOT FOUND” option
07:03 – XLOOKUP wildcard character match
09:20 – XLOOKUP…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads