slab where value fits range in Excel

Q23. In Excel, how can I find the slab in which a given value fits? (Grade given marks and Grading definitions, similarly Tariff rate given electricity consumption and Tariff table, Income Tax Rate given Income and Tax slabs)

For example, I want to get the grade given marks secured and grade definition Table.

To do it in Excel, here is the answer:

a) Enter the formula =VLOOKUP(Q3,L3:N16,3) where L3:N16 has grade definition slabs, Q3 represents the marks secured and 3 represents the column no. which has the desired results (Grade in this case).

excel slab where value fits range

 

You can find similar Excel Questions and Answer hereunder

1) How can I get an estimate of Standard Deviation of a sample dataset?

2) How can I add a Prefix to a set of numbers in a range?

3) How can I remove hyperlinks from a range of cells?

4) How can I prevent users from entering duplicate values in a range?

5) How can I quickly remove all blank cells in a data range?

6) How to read a value from a cell in vba in Excel

7) Vlookup to return max value from multiple hits in Excel

8) How can I fill a range of cells with incremental times?

9) Is there a way I can easily identify the duplicate values in a dataset?

10) How do I get the 2nd highest number in a range of numbers?

11) Is there a way to get a log value of a number using Excel?

12) How can I ensure that user enters only certain acceptable values in an input cell?

13) How can I find the sum of records that meet a given condition in my raw data table?

14) How can I set up a dynamic named range that expands automatically when new items are added to the list?

15) How can I set FreezePanes in a certain range using VBA?