How to use XLOOKUP in Excel Office 365 (New!)

Показать описание

Learn how to use XLOOKUP in Excel Office 365. It is an exciting new feature in Excel 365 for those who are in the Office Insider Program. The Xlookup formula is a new & simpler lookup function that replaces Hlookup, Vlookup as well as Index and Match functions.

**Link to Free Excel Mini-Course**

What is covered in this Excel tutorial:
==============
1. How to find the Xlookup function
2. Format and arguments of the function
3. Example of using the lookup function
4. How to extend the formula easily to other cells
5. Comparison Xlookup vs Vlookup - the many advantages of xlookup function. 3:53
6. How to lookup columns to the left using Xlookup 5:58
7. Comparison Xlookup vs Hlookup 7:06
8. How to lookup values from bottom-up as well as top-down: 8:03
9. Understanding Match Mode and Search Mode options in Xlookup
10. How to use Match mode in Xlookup 11:00
11. How to use Nested Xlookup 13:25

#ramgopalexcel

Рекомендации по теме

Комментарии

Really awesome. would be better if you provide a link to download worksheet to follow along.

rajeevgosavi

perfect!!! thanks for the help! best explanation out there

troycantrell

Ramgopal sir ! This is the awesome explanation of xlookup....It's really helpful....and the way u explained makes it like
I also using ur presentations skill tutorials from last few yrs nd gave me a lot of skills to present & design presentations.

VinitRatan

So awesome! Thank you for making it super easy!

humannature

This is awesome! Thank you so much! Quick question, what if you are doing a lookup that contains the name? For example the following: university of California, University of California Los Angeles or simply UCLA are names for UCLA. How can I perform this search and have it give me UCLA when searching the 3 different name formats?

dubbs

Iam a new subscriber...It's really awesome explanation which I never heard from others. Looking for more videos in Excel & ppt..Keep this rolling & God bless you.

apn