In this video, we look at 8 Excel XLOOKUP function examples to show off the power and versatility of this brilliant Excel function.
Learn ALL the best Excel functions - amzn.to/3Rg87Go
You can download the file to follow along here - www.computergaga.com/_excel/f...
Here are the chapters of the video contents;
00:00 Introduction
00:34 Classic XLOOKUP and dynamic array behaviour
03:12 Range lookup with XLOOKUP
05:32 Rank the top 5 products by sales value
07:52 Return the last match in a list
09:27 Two way lookup with two XLOOKUPs
12:23 Multiple criteria lookup
14:08 Interactive chart
17:02 XLOOKUP to help a complex COUNTIF
We start with a typical XLOOKUP example to look up some data and then progress through a variety of scenarios where XLOOKUP helps achieve our goal easily.
These include ranking values, creating dynamic charts, analysing with COUNTIF and performing a lookup with multiple criteria.
This function is a great VLOOKUP alternative. But also a great alternative to HLOOKUP and the INDEX/MATCH combination.
By the end of these Excel XLOOKUP function examples, you will know why we are all excited about this Excel function.
Find more great free tutorials at;
www.computergaga.com
** Online Excel Courses **
The Ultimate Excel Course - Learn Everything ► bit.ly/UltimateExcel
Excel VBA for Beginners ► bit.ly/37XSKfZ
Advanced Excel Tricks ► bit.ly/3CGCm3M
Excel Formulas Made Easy ► bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► bit.ly/2Siivkm
Connect with us!
LinkedIn ► / 18737946
Instagram ► / computergaga1
Twitter ► / computergaga1
Негізгі бет Тәжірибелік нұсқаулар және стиль Excel XLOOKUP Function Examples - 8 Useful XLOOKUP Examples
Пікірлер: 55