Excel Magic Trick 1274

VLOOKUP Replaces Long IF Formula for Conversion Formula (LOOKUP too)

DESCRIPTION

Learn how to avoid long formula with multiple IF Functions by using the lookup functions: VLOOKUP or LOOKUP. Also see a “Partial Text Lookup” Situation where we have to lookup just part of a text string.
(00:12) Problem Setup
(00:57) Solution #1: RIGHT, LEFT, SEARCH and VLOOKUP functions
(04:37) Solution #2: RIGHT, LEFT, SEARCH and LOOKUP functions and hard coded array for table

WORKBOOKS




Be the first to comment

Leave a Reply