multiple criteria Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/multiple-criteria/ Bestselling Excel and Power BI Courses Thu, 24 Aug 2023 15:32:44 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png multiple criteria Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/multiple-criteria/ 32 32 How To Use Excel FILTER Function With Multiple Criteria https://www.xelplus.com/excel-filter-function-with-multiple-criteria/ Thu, 24 Aug 2023 15:02:59 +0000 https://www.xelplus.com/?p=17612 Learn to use Excel's FILTER function with multiple criteria (AND/OR) and how to return only the columns you need with the help of CHOOSECOLS.

The post How To Use Excel FILTER Function With Multiple Criteria appeared first on Xelplus - Leila Gharani.

]]> 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.

]]>