ashok89jan
New Member
- Joined
- Jun 21, 2021
- Messages
- 5
- Office Version
- 365
- Platform
- Windows
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?
...... till
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 |