Article updated on July 31, 2017

Problem: Values between 0 and 4 returns Small. Values between 5 and 9 returns Medium. Values between 10 and 15 returns Large?


Categorize numbers

Formula in cell B1:


Looks up a value either from one-row or one-column range or from an array. Provided for backward compability.