Photo Gallery

Excel Magic Trick 465: Lookup Entire Row (ALL COLUMNS) with INDEX for Cake Manufacturing Calculation
Excel Magic Trick 874: Lookup That Rounds To The Nearest Number (Increment Unequal) INDEX & MATCH
Excel Magic Trick 977: Lookup First Non Empty Cell In A Range, Lookup Last Number In A Range
Excel Magic Trick 881: Lookup Picture with INDEX & MATCH functions instead of INDIRECT Function
Excel Magic Trick 1000: Lookup Last Partial Text Item using SEARCH and LOOKUP functions
Multiple Discount Lookup Tables!?!? LOOKUP & FILTER Functions. Excel Magic Trick 1832
Excel Magic Trick 873: VLOOKUP - Lookup that rounds to the nearest number (Increment Equal)
Excel Magic Trick 1001: Lookup Biggest Number After Partial Text Lookup, Many Duplicates
Excel Magic Trick 871: Lookup Last Line In A Cell: Formula w LEN, SUBSTITUTE, SEARCH, CHAR, MID
Excel Magic Trick 1192: Match Lookup Value to Closest Number in 1st Column of Lookup Table
Lookup Column with CHOOSECOLS, INDEX or XLOOKUP function? Excel Magic Trick 1835
Excel Magic Trick 922: Lookup Row, Then Lookup Value In Row & Return Column Header: Two Way Lookup