## Excel: Using lookup to categorize numbers

*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?

**Solution:**

**Formula in cell B1:**

=LOOKUP(A1,{0;5;10},{"SMALL";"MEDIUM";"LARGE"})

**LOOKUP(**lookup_value,array**)**

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

In this post I am going to show how to create a new sheet for each airplane using vba. The […]

This blog article describes how to split strings in a cell with space as a delimiting character, like Text to […]

This post describes how to split words in a cell range into a cell each using a custom function. I […]

Question: How do I divide values equally into groups (3 lists or less)? This post shows you two different approaches, […]

Here are the prerequisites. Column A contains dates, column B are categories and column C are values. The goal with […]

In a previous post I created unqiue distinct column headers (A20:C20) and then categorized adjacent cell values into each column […]

In a previous post I described how to simplifiy data entry. Now it is time to put values in separate […]

I am fairly new to vba and I am amazed of how much you can automate in excel. In this […]

This workbook lets you split expenses evenly with other people. Type name, expense and amount in the excel table on […]

### 3 Responses to “Excel: Using lookup to categorize numbers”

### Leave a Reply

**How to add a formula to your comment:**

<code>your formula</code>

Remember to convert less than and larger than signs to html character entities before you post your comment.

**How to add VBA code to your comment:**

[vb 1="vbnet" language=","]

VBA code

[/vb]

**How to add a picture to your comment:**

Upload picture to postimage.org

Add picture link to comment.

**Contact Oscar**

You can contact me through this webpage

This code does not work. Tried it several times.

fleury64

Wow! A post from 2007. Try this formula:

=LOOKUP(A1,{0;5;10},{"SMALL";"MEDIUM";"LARGE"})

[…] Excel: Using lookup to categorize numbers | Get Digital Help – Microsoft Excel resource […]