Excel Magic Trick 1305

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

DESCRIPTION

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.

WORKBOOKS

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




Be the first to comment

Leave a Reply