Photo Gallery

Excel Magic Trick 309: Partial Text Match: Why 2^15?
Excel Magic Trick 1111: Item In Both Lists? Extract With Better Array Formula
Excel Magic Trick 1000: Lookup Last Partial Text Item using SEARCH and LOOKUP functions
Excel Magic Trick 1029: DON'T Use IFERROR, Use IF and Logical Test If Possible...
Excel Magic Trick 913: Select From Drop Down and Pull Data From Different Sheet
Excel Magic Trick 1120: Is Item in All Three Lists?
Excel Magic Trick 699: VLOOKUP Mixed Number & Letter Partial Text Extract For Lookup Value
Excel Magic Trick 1031: Four Way Lookup Formula To Deliver Multiple Items From 1 of 2 Lookup Tables
Excel Magic Trick 323: Partial Text VLOOKUP (Fuzzy Match)
Excel Magic Trick 1092: Count Double, Triple, Quadruple, Quintuple Occurrences in Excel
Excel Magic Trick 1001: Lookup Biggest Number After Partial Text Lookup, Many Duplicates
Excel Magic Trick 1253: Can I Make VLOOKUP Use Column Headers? Yes: Use VLOOKUP & MATCH!

Related Archives

Excel Magic Trick 309: Partial Text Match: Why 2^15? Excel Magic Trick 1111: Item In Both Lists? Extract With Better Array Formula Excel Magic Trick 1000: Lookup Last Partial Text Item using SEARCH and LOOKUP functions Excel Magic Trick 1029: DON'T Use IFERROR, Use IF and Logical Test If Possible... Excel Magic Trick 913: Select From Drop Down and Pull Data From Different Sheet Excel Magic Trick 1120: Is Item in All Three Lists? Excel Magic Trick 699: VLOOKUP Mixed Number & Letter Partial Text Extract For Lookup Value Excel Magic Trick 1031: Four Way Lookup Formula To Deliver Multiple Items From 1 of 2 Lookup Tables The Shocking Truth Behind Robert Ward Frazier's Forgotten Case BST To PST: Time-Zone Tipping Point Or Game-Changing Moment For Your Business? The Kingman AZ Furniture Market's Dark Secret: What Buyers Need To Know Linda Darby's Unconventional Path To Success: An Inside Look From Fame To Fallout: What Can We Learn From Ruby Franke's Sons Wounds How Sinbad's Rise To Fame Will Skyrocket His Net Worth By 2024 The Free Stuff Pitfall: How Pittsburgh Craigslist Scams Could Be Costing You McDonald's Workers Say They're Not Getting Paid What The Company Claims - What's The Truth?