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

Download Excel Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT960-963.xlsx Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htm Lookup 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 quantity 2. 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 VLOOKUP This video covers the classic two-way lookup problem and will compare and contrast two methods: 1) INDEX and 2 MATCH functions 2) VLOOKUP and MATCH functions