Main Profile

At A Glance

Excel Magic Trick #128: VLOOKUP Categories

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.
Length: 04:54

Contact

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.

  • Answer

Ask a New Question