VLOOKUP Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/vlookup/ Bestselling Excel and Power BI Courses Fri, 24 Mar 2023 06:00:27 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png VLOOKUP Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/vlookup/ 32 32 Best 10 Excel Functions for Accountants https://www.xelplus.com/excel-functions-for-accounting/ Thu, 25 Feb 2021 10:00:00 +0000 https://www.xelplus.com/?p=10260 Make sure you know these Excel functions if you work in Accounting, Finance or you are a Data Analyst. They'll make your work life a LOT easier and they work in all Excel versions (such as AGGREGATE, TRIM, ROUND & more)

The post Best 10 Excel Functions for Accountants appeared first on Xelplus - Leila Gharani.

]]> How to Use Excel IFS Function https://www.xelplus.com/excel-ifs-function/ Thu, 09 Jul 2020 10:48:00 +0000 https://www.xelplus.com/?p=10875 The IF function is one of the most popular functions in Excel. But what about the IFS function? Does it really make writing nested IF functions easier? Let's find out.

The post How to Use Excel IFS Function appeared first on Xelplus - Leila Gharani.

]]> How to Create Excel Interactive Charts with Dynamic Arrays https://www.xelplus.com/excel-da-dynamic-sorted-chart/ Thu, 19 Mar 2020 10:00:00 +0000 https://www.xelplus.com/?p=11421 Create an automatically sorted Excel bar chart that ALSO lets you hide and show categories based on a flag in the cell. It's super easy with Excel dynamic arrays.

The post How to Create Excel Interactive Charts with Dynamic Arrays appeared first on Xelplus - Leila Gharani.

]]> Top 5 Excel Interview Questions https://www.xelplus.com/top-5-excel-interview-questions/ Thu, 10 Oct 2019 09:00:00 +0000 https://www.xelplus.com/?p=12068 Make sure you know the answers to these Excel Interview questions before you go to your next interview. These are asked specially if you're applying for data analyst jobs.

The post Top 5 Excel Interview Questions appeared first on Xelplus - Leila Gharani.

]]> VLOOKUP Explained with 2 Practical Examples https://www.xelplus.com/basics-vlookup-hlookup/ Thu, 13 Sep 2018 08:00:00 +0000 https://www.xelplus.com/?p=9659 Quickly learn Excel's VLOOKUP formula and get it working in your own files. I also show you common mistakes made here, so watch out for these when writing the VLOOKUP.

The post VLOOKUP Explained with 2 Practical Examples appeared first on Xelplus - Leila Gharani.

]]> Lookup Values Across Multiple Worksheets in Excel https://www.xelplus.com/lookup-values-across-multiple-worksheets-excel/ Fri, 17 Nov 2017 07:40:00 +0000 https://www.xelplus.com/?p=11271 In this tutorial, we will address how to lookup values in multiple tabs using a single formula. You will see one method using VLOOKUP and direct worksheet and cell references, and another using INDEX & MATCH and Excel Table names and references. Both approaches rely on the INDIRECT function to return the correct sheet address in a dynamic way.

The post Lookup Values Across Multiple Worksheets in Excel appeared first on Xelplus - Leila Gharani.

]]>