Main Profile

At A Glance

Excel Magic Trick 963: Lookup Product Price Based On Quantity: Two Way Lookup

Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htmLookup Product Price Based On Quantity: Two Way Lookup:1. INDEX function for two way lookup and then MATCH function with Exact Match for Row number and MATCH function with approximate match for quantity2. VLOOKUP function to do an exact match for product name and then MATCH function with approximate match for quantity to determine the column umber in the third argument of VLOOKUPThis video covers the classic two-way lookup problem and will compare and contrast two methods:1) INDEX and 2 MATCH functions2) VLOOKUP and MATCH functions
Length: 11:09

Contact

Questions about Excel Magic Trick 963: Lookup Product Price Based On Quantity: Two Way Lookup

Want more info about Excel Magic Trick 963: Lookup Product Price Based On Quantity: Two Way Lookup? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question