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.
Leave a Reply
You must be logged in to post a comment.