See when to use IF and when to use VLOOKUP depending on your category setup. See when the VLOOKUP function beats the IF function, but only if categories are Appropriate. Also, see how to use the formula construct (1-VLOOKUP) to calculate a discounted total.
Questions about Excel Magic Trick #128: VLOOKUP Categories
Want more info about Excel Magic Trick #128: VLOOKUP Categories?
Get free advice from education experts and Noodle community members.