Main Profile

At A Glance

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

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm 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
Length: 08:35

Contact

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

Want more info about Excel Magic Trick 874: Lookup That Rounds To The Nearest Number (Increment Unequal) INDEX & MATCH? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question