Excel Forum

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.

Got a Question? Ask it Here in the Forum.