Title:
Excel Lookup and Search Tip 9 - Vlookup to Return Prices with Quantity Discounts for Orders in Excel
Video:
Description:Visit 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 There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Published:
17/Nov/2009
Excel Lookup and Search Tip 9 - Vlookup to Return Prices with Quantity Discounts for Orders in Excel
Video:
Description:Visit 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 There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Published:
17/Nov/2009
No comments:
Post a Comment