Excel Magic Trick 1376

Complex VLOOKUP Formula To Create Transaction Description


See an amazing formula from Bill Szysz at YouTube to create a Description Column for a transaction table. Thanks to Michale Diamond for the good question. See the formula elements: Shirking Range (Contracting Range), MATCH function, Wild cards to lookup text that has one or more characters, Question Mark Wild Card, Asterisk Wild Card, IFERROR function, ROWS function, VLOOKUP Function, IF Function. Also see Formula Evaluator to step through formulas to see the steps of evaluation.


Download “Excel Magic Trick 1361-1380” Excel-Magic-Trick-1361-1380.zip – Downloaded 551 times – 14 MB

Be the first to comment

Leave a Reply