XLOOKUP Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/xlookup/ Bestselling Excel and Power BI Courses Fri, 07 Mar 2025 14:53:21 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png XLOOKUP Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/xlookup/ 32 32 XLOOKUP vs VLOOKUP https://www.xelplus.com/xlookup-vs-vlookup/ Tue, 19 Mar 2024 10:17:31 +0000 https://www.xelplus.com/?p=21968 For a long time, VLOOKUP was the go-to way to find things in Excel. But now that more people can use XLOOKUP, VLOOKUP's top spot is in question. XLOOKUP is a newer, better tool for looking up things in Excel. It's more powerful than VLOOKUP. Let's compare the two.

The post XLOOKUP vs VLOOKUP appeared first on Xelplus - Leila Gharani.

]]> Excel Dashboard to Track Budget and Actuals with Variances https://www.xelplus.com/excel-budget-actual-dashboard/ Fri, 08 Dec 2023 14:25:28 +0000 https://www.xelplus.com/?p=19902 Learn to build a budget vs actual dashboard in Excel. Master key formulas and chart customization for effective year-over-year variance analysis.

The post Excel Dashboard to Track Budget and Actuals with Variances appeared first on Xelplus - Leila Gharani.

]]> How to use Excel’s LOOKUP Function https://www.xelplus.com/excel-lookup-function/ Thu, 05 May 2022 08:00:00 +0000 https://www.xelplus.com/?p=9330 The lookup function is the simplest function in Excel. It can return exact or approximate matches and it's super easy to write. Yet many people prefer VLOOKUP because it's easier to understand. In this tutorial, I'll explain the LOOKUP function by using a simple, followed by a more complex example.

The post How to use Excel’s LOOKUP Function appeared first on Xelplus - Leila Gharani.

]]> Must-Know Excel Functions for 2024 https://www.xelplus.com/excel-functions-office-365/ Thu, 07 Jan 2021 10:00:00 +0000 https://www.xelplus.com/?p=10369 This is the list of the most useful, new Excel Functions you need to know. These will save you from wasting time with complex formulas!

The post Must-Know Excel Functions for 2024 appeared first on Xelplus - Leila Gharani.

]]> Practical Excel Dashboards Tips – Ideas to Get Creative https://www.xelplus.com/excel-hash-2019/ Wed, 11 Dec 2019 03:18:00 +0000 https://www.xelplus.com/?p=11674 This Excel dashboard combines 4 strange features to create a dynamic and practical dashboard. It includes FILTER function with XLOOKUP, XOR function, Linked Picture as well as an Icon. You'll find a lot of hidden gems in the way this Excel dashboard was created.

The post Practical Excel Dashboards Tips – Ideas to Get Creative appeared first on Xelplus - Leila Gharani.

]]> How to Use Excel XLOOKUP Function – 5 Examples https://www.xelplus.com/excel-xlookup-advanced/ Thu, 28 Nov 2019 10:00:00 +0000 https://www.xelplus.com/?p=11766 Excel's New & Improved XLOOKUP function will be the answer to most of your Excel Lookup problems. Learn from these 5 examples to see how you can apply the new XLOOKUP function to your files.

The post How to Use Excel XLOOKUP Function – 5 Examples appeared first on Xelplus - Leila Gharani.

]]> How to do a Left LOOKUP with XLOOKUP https://www.xelplus.com/excel-lookup-to-the-left-with-xlookup/ Thu, 21 Nov 2019 11:37:00 +0000 https://www.xelplus.com/?p=9417 If you'd like to do a lookup to the left in Excel use the new XLOOKUP function. Forget about using INDEX MATCH or a VLOOKUP workaround. Just go with XLOOKUP.

The post How to do a Left LOOKUP with XLOOKUP appeared first on Xelplus - Leila Gharani.

]]> Excel XLOOKUP Function https://www.xelplus.com/excel-xlookup/ Thu, 12 Sep 2019 09:00:00 +0000 https://www.xelplus.com/?p=12219 Discover what Excel's NEW XLOOKUP Function can do for you and how it can help you with your Excel lookup problem. In this example we use XLOOKUP to lookup values on another sheet (Yes - No more VLOOKUP for these tasks!)

The post Excel XLOOKUP Function appeared first on Xelplus - Leila Gharani.

]]>