URGENT help needed!...Excel lookup function

[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!