Comparison of multiple "Between"s / Categorisation

[Dawnscream]

Hi everyone!

Excel: 2013
Windows: Windows 7 64bit

I'm trying to solve an evaluation/comparison of multiple "between" analyses. I'll try to describe it better with an example:

I am trying to do the following:

- I wish to analyse the numbers in the column B, and depending whether the value is between 0 to 3, or 4 to 6, or 7 to 13, or 14 to above 14, I want to fill the Blue column with the resulting category number.
- The ideal result will execute the comparison and give out a 1,2, 3 or 4 into Column C, depending on what the value in Colum B is.

I hope I am clear. If anything is not clear, please ask and I'll try to describe. I tried browsing questions/help about similar issues, but I can't seem to find a solution.

Thank you all so much for your time and effort invested!

 

[FormR]

Welcome to the forum!

If if really is just 1,2,3,4 to return you could try in cell C4 and copied down.

=MATCH(B4,$E$4:$E$7)

For more flexibility on what to return try:

=LOOKUP(B4,$E$4:$E$7,$G$4:$G$7)

 

[gaz_chops]

Try

=LOOKUP(B4,$E$4:$E$7,$G$4:$G$7)

 

[Dawnscream]

Ah, this does exactly what I was after! Thank you a lot!