Excel Forum
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 Lookup & Search Tip 9 - Vlookup to Return Prices with Quantity Discounts for Orders in Excel

This Excel Video Tutorial will show you how to use the VLOOKUP() function in Excel in order to return quantity discount prices from a table. This allows you to quickly return the prices for products based on the quantity of that product that is ordered.

This tutorial shows you how to use the VLOOKUP() function in order to return an approximate match for numbers. The important thing to remember is that you will have to sort the numbers being searched in ascending order. This is a great tutorial for those looking to learn how to use the VLOOKUP() function in Excel.
   Topics Covered
VLOOKUP() function in Excel.
Search lists and databases in Excel.
Determine quantity price discounts in Excel.
General lookup and search tutorial using the approximate feature of the vlookup function in Excel.
   Difficulty:         Intermediate
   Video:               Yes

Got a Question? Ask it Here in the Forum.