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