matrix lookup Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/matrix-lookup/ Bestselling Excel and Power BI Courses Fri, 24 Mar 2023 05:38:39 +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.

]]> INDEX & MATCH for Flexible Lookups 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 INDEX & MATCH for Flexible Lookups appeared first on Xelplus - Leila Gharani.

]]>