Evaluate Formula Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/evaluate-formula/ Bestselling Excel and Power BI Courses Thu, 02 Mar 2023 17:28:29 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Evaluate Formula Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/evaluate-formula/ 32 32 Excel Lookup Multiple Criteria in Rows or Columns https://www.xelplus.com/excel-index-and-match-2/ Thu, 17 Aug 2017 22:18:00 +0000 https://www.xelplus.com/?p=11994 Learn how to perform a matrix lookup, i.e. when you need to return the value based on the header row and the category column, in a scenario where you have more than one header. The powerful INDEX/MATCH combo is capable of handling that a couple of ways.

The post Excel Lookup Multiple Criteria in Rows or Columns appeared first on Xelplus - Leila Gharani.

]]> Excel Debug Formulas and Correct Errors https://www.xelplus.com/excel-debug-formula/ Tue, 23 Aug 2016 10:35:00 +0000 https://www.xelplus.com/?p=13120 In this video tutorial, you will learn about the various tools you can find under the Formula Auditing group in Excel that can help you figure out the problem whenever you get stuck or your formula throws an error.

The post Excel Debug Formulas and Correct Errors appeared first on Xelplus - Leila Gharani.

]]>