How To Assign Grade By Using Lookup Function In Excel Sheet
In this video, we will learn how to assign a grade using the LOOKUP function in Excel. I have student names, total percentage, and grades. I will use the LOOKUP function to calculate grades as per the percentage by selecting the percentage and grade columns and fixing them with F4.
After entering the formula, I will drag it down to apply the grades to all students. If you like this video, please subscribe to my channel. Thank you so much!