Lookup function
 

I have excel 2003. I did a vlookup for my transcripts page. In the first
vlookup i needed it to look for the letter grade and give me the gradepoint
average. Now in the other cell i need it to look for the grade. In the cell
that gives the gradepoint average it has a formula in their already. Can i
still do a vlookup if the cell that has the information has a formula in it
already. Example. The cell that has the formula adds all the grades from
each class and gives me an accumluated gradepoint average for the ten classes
taken. Now that gradepoint average I want a letter for it. How would i do
this or can it be done.

Lookup function
 

Hi Marvin,

I have a worksheet that I believe is an example of what you want to do.
Would require some adaptation to suit your final needs.

You enter the letter grades for each student and it provides a GPA and an
average letter grade.

So if a student has the following letter grades, F, A, B, C, A, D, returns a
GPA of 2.33 and average letter grade of B-. The scales are adjustable to
suit your requirements.

contact me

Regards,
Howard

"marvin" wrote in message
...
I have excel 2003. I did a vlookup for my transcripts page. In the first
vlookup i needed it to look for the letter grade and give me the
gradepoint
average. Now in the other cell i need it to look for the grade. In the
cell
that gives the gradepoint average it has a formula in their already. Can
i
still do a vlookup if the cell that has the information has a formula in
it
already. Example. The cell that has the formula adds all the grades from
each class and gives me an accumluated gradepoint average for the ten
classes
taken. Now that gradepoint average I want a letter for it. How would i
do
this or can it be done.