Excel Forum
Similar Content
How to use Vlookup Across Multiple Worksheets in Excel
Tutorial: This tutorial shows you how to use the Vlookup function across multiple worksheets within ...
Remove Vlookup #N/A Error in Excel
Tutorial: How to remove the #N/A error from Vlookup and replace it with a friendly message or a bl...
Understanding Formulas and Functions in Excel
Tutorial: In this tutorial I will cover the basic concepts of Formulas and Functions in Excel. A for...

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.