Hi all,

I'm trying to assign a number to a value range in a specific cell, then output that number to another cell.

For instance, in cell A1 I may have: 100-105 (with an assigned value of 1), 106-110 (with an assigned value of 2), 111-114 (with an assigned value of 3), 115-119 (with an assigned value of 4).

So when you type in, say, 107 in cell A1, it places the number 2 in an output cell (for example, B1).

How could I accomplish this? On some cells there will be 4 sets of variables, and on some there will only be 2 or 3. I imagine the formula would just repeat itself based on how many variable ranges I have?