Show students grade based on their obtain marks using VLOOKUP Formula in Google spreadsheet - codylab

VLOOKUP FORMULA - GOOGLE SHEET.

Get students' Grade through =VLOOKUP() formula in g-sheet.

        If you want to get Grade of your students to show their possition in their class, then vlookup formula is more useful for you to use. You shoulld use vlookup formula get the students' grade.

The syntax for the Google Sheets VLOOKUP function is as follows:

=VLOOKUP(search_key, range, index, [is_sorted])

The first 3 arguments are required, the last one is optional:

• Search_key - is the value to search for (lookup value or unique identifier). For example, you can search for the word "apple", number 10, or the value in cell A2.
• Range - two or more columns of data for the search. The Google Sheets VLOOKUP function always searches in the first column of range.
• Index - the column number in range from which a matching value (value in the same row as search_key) should be returned.

The first column in range has index 1. If index is less than 1, a Vlookup formula returns the #VALUE! error. If it's greater than the number of columns in range, VLOOKUP returns the #REF! error.

• Is_sorted - indicates whether the lookup column is sorted (TRUE) or not (FALSE). In most cases, FALSE is recommended.

To see the example sheet:Click here

In above sheet, we are looking up the value of cell E4 (which is the percentage value of total obtained marks of a student's ID: E0001) in cells B2,C2,D2,E2 and spected results as follows:

• If  E4 cell value <= E2 but not greater than D2, result comes E1 (Fail division).          or
• If  E4 cell value <= D2 but not greater than C2, result comes D1 (Third division).          or  
• If  E4 cell value <= C2 but not greater than B2, result comes C1 (Second division).          or
• If  E4 cell value <= B2, result comes B1 (First division).

Note:- 

1. You can change value of cell B1,C1,D1 and E1  into Grade to get result in Grade. e.g: Grade A, Grade B, Grade C and Grade D.
2. You can manage value of cell B2,C2 and D2  to change out comes. e.g. if you change the cell B2 with 70, students need 70% of marks to get result First divion  or Grade A.

DEMO SHEET LINK

>>>TRY TO CHECK OUT , IF ANY ERROR FOUND. PLEASE LET ME KNOW BY COMMENT.

I'LL TRY MY LEVEL BEST TO FIX THE PROBLEM. THANKS FOR VISITING CODYLAB Have a nice day! 

-------------------------- -------------------------  

Donate me through - PayPal or RozorPay or Paytm