Hello everyone,

I am trying to get values as per their property (see image).

As you can see, there is 65 written in column D with property Excellent next to it, then on next cell I have put a formula that should search from table (on right side) and show Demand type (20, 30, 40...), in this case 20 because 65 with excellent property lies under 20 demand. Similarly, if the number comes under Very Good column then it should show respective Demand number.

I have tried searching over the internet but nothing is working. I know my formula is wrong. I wonder if you experts can help me up?

Moreover, please also tell how to put range of specific numbers in one cell, for example, 01-65, 66-75 and so.

P.S. I am not excel expert.

Many thanks for your support.