Excel Magic Trick 1376

Complex VLOOKUP Formula To Create Transaction Description

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.

WORKBOOKS

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







Be the first to comment

Leave a Reply