Excel Magic Trick 1305

Adding Multiple Two-Way Lookups INDEX function & N(IF(1,Array) Trick


Learn how to perform multiple two-way lookups for a cross tabulated table to get multiple sales numbers and then add them using an array formula. Learn how to get INDEX function to deliver an Array of Items using N(IF(1,Array) Trick.


Download “Excel Magic Trick 1301-1320” Excel-Magic-Trick-1301-1320.zip – Downloaded 522 times – 285 KB

Be the first to comment

Leave a Reply