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).