matrix lookup Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/matrix-lookup/ Bestselling Excel and Power BI Courses Tue, 25 Jun 2024 05:12:31 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png matrix lookup Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/matrix-lookup/ 32 32 Excel Reverse Matrix Lookup https://www.xelplus.com/excel-reverse-matrix-lookup/ Fri, 21 Jul 2017 14:35:00 +0000 https://www.xelplus.com/?p=12162 In this tutorial, we tackle a matrix lookup scenario, where you want to return the column header based on the value inside the matrix as well as the row header. INDEX/MATCH to the rescue.

The post Excel Reverse Matrix Lookup appeared first on Xelplus - Leila Gharani.

]]> How to Use INDEX and MATCH in Excel https://www.xelplus.com/excel-index-and-match/ Fri, 03 Mar 2017 12:45:00 +0000 https://www.xelplus.com/?p=12618 Learn how the INDEX and MATCH functions work individually and how putting them together allows you to conduct flexible lookups.

The post How to Use INDEX and MATCH in Excel appeared first on Xelplus - Leila Gharani.

]]>