Hello hello,
I'm trying to find a way to return which category a certain value belongs in, based on a range of values.
Basically, in the table below, I'm trying to find the formula of E5, based on the value found in E2. The formula in E5 should be returning 3.
*Important, this example uses a small table, but I'm working with a very long list of values to find the category for, therefore I'm trying to avoid the formula (IF(AND(E2=>B2,E2=<C2)),A2,IF(...
A huge thank you in advance.
Manon
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]CATEGORY[/TD]
[TD]MIN[/TD]
[TD]MAX[/TD]
[TD][/TD]
[TD]VALUE[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]10[/TD]
[TD][/TD]
[TD]20.2[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2[/TD]
[TD]10[/TD]
[TD]20[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]3[/TD]
[TD]20[/TD]
[TD]30[/TD]
[TD][/TD]
[TD]RANGE[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]4[/TD]
[TD]30[/TD]
[TD]40[/TD]
[TD][/TD]
[TD]???[/TD]
[/TR]
</tbody>[/TABLE]
I'm trying to find a way to return which category a certain value belongs in, based on a range of values.
Basically, in the table below, I'm trying to find the formula of E5, based on the value found in E2. The formula in E5 should be returning 3.
*Important, this example uses a small table, but I'm working with a very long list of values to find the category for, therefore I'm trying to avoid the formula (IF(AND(E2=>B2,E2=<C2)),A2,IF(...
A huge thank you in advance.
Manon
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]CATEGORY[/TD]
[TD]MIN[/TD]
[TD]MAX[/TD]
[TD][/TD]
[TD]VALUE[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]10[/TD]
[TD][/TD]
[TD]20.2[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2[/TD]
[TD]10[/TD]
[TD]20[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]3[/TD]
[TD]20[/TD]
[TD]30[/TD]
[TD][/TD]
[TD]RANGE[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]4[/TD]
[TD]30[/TD]
[TD]40[/TD]
[TD][/TD]
[TD]???[/TD]
[/TR]
</tbody>[/TABLE]
Last edited: