Main Profile

At A Glance

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