Check a number is between two columns and then pick a value

[ashok89jan]

I have the data like given below till Low =0.5, High= 1.49, and Grade = 1 My need is, if I enter a number in a different cell, say 95, I need that to be compared with the entire Low and High columns and find in between which range it sits in (In the below sample it sits between Low= 94.5 and High 95.49), then pick the Grade for this range (which in the sample is 95). Can someone please help. Can we do this without VBA?

Low	High	Grade
99.5​	100​	100​
98.5​	99.49​	99​
97.5​	98.49​	98​
96.5​	97.49​	97​
95.5​	96.49​	96​
94.5​	95.49​	95​
93.5​	94.49​	94​
92.5​	93.49​	93​
91.5​	92.49​	92​
90.5​	91.49​	91​
89.5​	90.49​	90​

...... till

3.5​	4.49​	4​
2.5​	3.49​	3​
1.5​	2.49​	2​
0.5​	1.49​	1​

 

[mikerickson]

This worked for me. Thank you so much. Could you please give a brief on how this worked or the logic behind this, to learn the same
And thank you, everyone, for the support

That's what VLOOKUP does, return values in one column that match a given value in another column. Excel's on board help would explain it better than I could.