Excel Lookup & Search Tip 9 - Vlookup to Return Prices with Quantity Discounts for Orders in Excel

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
4,117
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Nov 16, 2009

Visit http://www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials.

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.

For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.

Have a great day!

  • likes, 0 dislikes

Link to this comment:

Share to:
see all

All Comments (2)

Sign In or Sign Up now to post a comment!
  • There is really a lot that could be going on with that question depending on how the data is setup and organized and whether or not you want all of the results to be returned or not. You can send me the entire question if you want just PM me here.

  • great video i've been trying to look up how 2 use search functions in excel but cant find anything. Here is an example .... SEARCH for customers whose trip budget is at least £550 how would i do this  This is a question in a mock paper

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more