Two-way lookup with INDEX and MATCH approximate R.Admin 7 years ago Two-way lookup with INDEX and MATCH approximate # Share this:Print Why INDEX-MATCH Is Far Better Than VLOOKUP or HLOOKUP in ExcelDateOctober 27, 2014In relation toExcel TipsExcel Magic Trick 1137: Excel & PowerPivot DAX Formula: Approximate Match Lookup Without VLOOKUPDateMarch 25, 2017In relation toLearn ExcelLearn to use Vlookup in ExcelDateJuly 16, 2014In relation toSmart Excel Tips