Excel Magic Trick 874: Lookup That Rounds To The Nearest Number (Increment Unequal) INDEX & MATCH

Online Courses for microsoft excel :

Course updated 2012-03-02 21:55:33

Instructor : ExcelIsFun

Course Duration : 8:35

Rating : 5.00 / 5

Step by step & Descreption :
Download workbook:
Learn how to:
1. See how to avoid the default VLOOKUP behavior and instead find a value in the first column of the lookup table that is closest to the lookup Value
2. Array formula that uses INDEX, MATCH, ABS, MIN and a table sorted biggest to smallest Descending.
3. See array formula from Marcelo Branco at Mr Excel Message Board