Slab where value fits range in Excel

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 ensure that user enters only certain acceptable values in an input cell?

2) I am considering an investment of $500 per month for 3 years @ 6% interest rate. What is the Present Value of investment?

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

4) How can I filter a table to get all records that have less than a particular value in a specific column?

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

6) Is there a way to easily shade alternate rows in a data range for improving readability?

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

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

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

10) How can I see where page breaks occur before actually printing?


Here the previous and next chapter