7:59Excel Magic Trick 287: Lookup Adding - Array & Non-Array Formulaexcelisfun4.0K viewsView & Download
1:50XLOOKUP or VLOOKUP & Dynamic Arrays to Deliver Table of Lookup Values! –- Excel Magic Trick 1611excelisfun40.6K viewsView & Download
3:04Excel Magic Trick 1105: Minimum With Two Criteria: When NOT to use Array Formula: DMINexcelisfun7.0K viewsView & Download
6:26Excel Magic Trick 746: Payback Rule Dynamic Single Cell Array Formula LOOKUP function Array Magicexcelisfun20.3K viewsView & Download
17:18Excel Magic Trick 1271: Extract Top 20 Values & Dates: Formula, Array Formula or Power Query?excelisfun36.9K viewsView & Download
4:31Excel Magic Trick 364: Return First Non-Blank (Array Formula)excelisfun18.6K viewsView & Download
7:21Excel Magic Trick 602: SUMIF Does Lookup? Total Sales Array Formula w 1 Criteria SUMIF Functionexcelisfun10.7K viewsView & Download
5:17Excel Magic Trick 365: Return First Non-Blank (Not An Array Formula)excelisfun21.5K viewsView & Download
9:16Excel Magic Trick 1291: Reverse Lookup Array Formula to Score Myers-Briggs Testexcelisfun6.0K viewsView & Download
3:38Excel Table Column Formulas and Spilled Arrays? Excel Magic Trick 1679excelisfun20.3K viewsView & Download
11:16Excel Magic Trick 811:Multiple Two Way Lookup Adding INDIRECT, ADDRESS & Array MATCH Functionexcelisfun26.7K viewsView & Download
17:44Excel Magic Trick 473: Extract Unique Records with Formula (Complex Array Formula)excelisfun51.6K viewsView & Download
7:12Excel Magic Trick 1305: Adding Multiple Two-Way Lookups INDEX function & N(IF(1,Array) Trickexcelisfun8.1K viewsView & Download
8:32Excel Magic Trick 757: Two Lookup Values & 2 Lookup Columns? Great Formula INDEX & MATCHexcelisfun101.6K viewsView & Download
2:53Excel Formula To Randomly Lookup Pictures or Any Item. Excel Magic Trick 1823excelisfun7.3K viewsView & Download
18:09Excel Magic Trick 1445: Single Cell Array Formula: Count Customer Names for 8 Sales Coupon Groupsexcelisfun6.1K viewsView & Download
10:08Excel Magic Trick 1031: Four Way Lookup Formula To Deliver Multiple Items From 1 of 2 Lookup Tablesexcelisfun11.4K viewsView & Download
13:54Excel Magic Trick 609: Array Formula To Return Multiple Items - List Periods That Students Have Freeexcelisfun17.2K viewsView & Download