I think I am missing something

New Contributor

I hope that someone can point me in the right direction, I am trying to work out how to return a value when a number falls between to numbers. For example, if months fall between 36 and 39 in cell C6, then show 100 in a cell D6. of the months fall between 40 and 48 in cell C6 then show 80 in cell D6. and so on. 


IS this possible as I will be honest I am only really starting to delve into excel and trying to learn things on the fly. 


Cheers Rob

2 Replies


I'd create a small lookup table with the thresholds such as 36 and 40 in the first column, and the value to return in the second column. In the screenshot below, I used F2:G8 for this purpose, but you can place it anywhere, even on another worksheet. I added some extra rows as example, you'd have to change those to match your setup.

The formula in D6 is




This can be filled down if required.



@Hans Vogelaar 


Thank you so much that works a treat and will help me learn a little more about Excel