Excel Forum
Similar Content
Excel Date Filter Magic - Last Month, This Month, YTD & More + Awesome Interface
Tutorial: Learn to make a beautiful and intuitive date filtering interface for your data in Excel t...
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...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.