bit4bit

Hi, I have an excel project due in tomorrow morning, and one thing I have left to do is to:

"use the lookup function to to convert the average mark per student into degree classifications"

Basically I have a spread sheet describing students final marks for 11 different modules they took over the year. I have created another column to the right, which I have used the '=AVERAGE()' function on for each students average mark. I have then sorted them descending from highest to lowest mark.

What I need to do now is to use this 'lookup' function to assign a degree class to each student based on his/her average mark. All I am told is...

Average mark : Class
>=70 : first class
>=60,<70 : upper second
>=50,<60 : lower second
>=40,<50 : third
>=35,<40 : pass
<35 : fail

-----------key------------
< less than
>= greater than or equal to.
---------------------------

...you can see each average mark will fall within one of the above ranges, and be assigned to the respective class, but I am not told how to use this function in any way.
Basically I'm guessing I will just have to enter it in the first cell and copy down the column. But I cant actually figure out how to use the function itself.


Please if you have any idea of how to do this, help me out.

Thanks!
bit4bit

bit4bit

P.S. this has to be done using LOOKUP function and nothing else.

P.P.S I have found the function under: insert>function>lookup and reference> lookup, and then I get a smaller window with two options...

1.) lookup_value,lookup_vector,result_vector
2.) lookup_value,array

I think these are the parameters I need to enter but I'm not sure what each refers to.
I would have though average mark, range, and class name would have been what I needed?

bit4bit

..pffff excel noobs!

I sorted it in the end...was selecting the wrong data array....project submitted!