7:12Excel Magic Trick 1305: Adding Multiple Two-Way Lookups INDEX function & N(IF(1,Array) Trickexcelisfun8.1K viewsView & Download
11:16Excel Magic Trick 811:Multiple Two Way Lookup Adding INDIRECT, ADDRESS & Array MATCH Functionexcelisfun26.7K viewsView & Download
4:41Excel’s # 1 Silliest Formula: INDEX or INDIRECT? Excel Magic Trick 1571 (Two Way Lookup Trick)excelisfun11.1K viewsView & Download
18:07Excel Magic Trick 1352: Lookup 3 Items & Return to Single Cell VLOOKUP, INDEX or LOOKUP functions?excelisfun11.0K viewsView & Download
2:40Excel Two Way Lookup with VLOOKUP & MATCH Functions - Excel Magic Trick 1567excelisfun32.5K viewsView & Download
7:28Excel Magic Trick 1371: Excel Formula To Add Last Five Values in an Excel Table: INDEX Dynamic Rangeexcelisfun6.2K viewsView & Download
3:27Multiple Discount Lookup Tables!?!? LOOKUP & SWITCH Come to The Rescue. Excel Magic Trick 1831excelisfun5.7K viewsView & Download
8:13Excel Magic Trick 714: Three Criteria Lookup Adding SUMIF, INDEX, MATCH, SUMPRODUCT (2 examples)excelisfun209.2K viewsView & Download
2:27Excel Magic Trick 1187: Formula to Lookup Every 5th Item In a Column, INDEX and ROWS functionsexcelisfun7.2K viewsView & Download
55:04Excel Magic Trick 1375 Add w OR Logical Test from 2 Different Columns in 2 Diff. Tables (6 Examples)excelisfun11.5K viewsView & Download
3:35Multiple Discount Lookup Tables!?!? LOOKUP & FILTER Functions. Excel Magic Trick 1832excelisfun6.4K viewsView & Download
2:52INDEX Function To Lookup Column inside COUNTIFS Function - Excel Magic Trick 1574excelisfun26.9K viewsView & Download
14:42Excel Magic Trick 479: Reverse Two Way Lookup - Robust Formula for Duplicate Situationsexcelisfun16.4K viewsView & Download
14:45Excel Magic Trick 1290: VLOOKUP to Multiple Dynamic Lookup Tables Listed as Single Downloaded Tableexcelisfun23.1K viewsView & Download
11:27Excel Magic Trick 1205: Rearrange Data with INDEX Function & Formula Number Incrementersexcelisfun12.8K viewsView & Download
6:58Excel Magic Trick 1116: Lookup Every Third Item or Lookup Every "Nth" Item, 3 Formula Methodsexcelisfun24.6K viewsView & Download
25:02Excel XLOOKUP Function – Comprehensive Lessons – 27 Examples - Excel Magic Trick 1600excelisfun134.6K viewsView & Download
18:52Excel Magic Trick 1377: Lookup Formula To List All Incomplete Assignments: INDEX, TEXTJOIN & Moreexcelisfun12.6K viewsView & Download
3:563-Way Lookup Adding: XLOOKUP or INDEX inside SUMIFS? –- Excel Magic Trick 1602excelisfun58.3K viewsView & Download
24:28Excel Magic Trick 824: Two Way Lookup With More Than One Lookup Table Same or Different Sheetsexcelisfun32.9K viewsView & Download