vlookup function

  • Thread starter Thread starter blinkerbox
  • Start date Start date
B

blinkerbox

I am doing grading using excel. For grade percentages, I would like to
have the letter grade automatically calculated rather than figuring out
each student individually. The grade percentages are broken into 10s,
each one gets the next letter and after 60 is an F. How do I enter the
formula to automatically process the letter grade. Any help you can
give me is much appreciated. Thanks.:confused:
 
Hi Blinkerbox,

I've sent you an example by private e-mail which may help. Will need some
adjustments for sure, but it may get you going.

HTH
Regards,
Howard
 
Set up a table as follows
and assuming the percent is D1, then in E1

A B C D E
1 0% F 55% = vlookup(d1,A1:B5,2)
2 60% D
3 70% C
4 80% B
5 90% A
 
Blinkerbox,

You'll probably be copying Dale's formula down a column in your student
grades table. You'll need absolute cell references:

= vlookup(d1,$A$1:$B$5,2)

Why do they call it VLOOKUP? It doesn't look up. It looks down.

Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

Dale Hymel said:
Set up a table as follows
and assuming the percent is D1, then in E1

A B C D E
1 0% F 55% = vlookup(d1,A1:B5,2)
2 60% D
3 70% C
4 80% B
5 90% A
Click to expand...
 
Earl Kiosterud said:
Blinkerbox,

You'll probably be copying Dale's formula down a column in your student
grades table. You'll need absolute cell references:

= vlookup(d1,$A$1:$B$5,2)

Why do they call it VLOOKUP? It doesn't look up. It looks down.
Click to expand...

It looks on a _vertical_ axis for the index number. Might want to
contrast that with hlookup, which checks a horizontal axis.
 
Earl Kiosterud said:
Still think it oughtta be VLOOKDOWN.
Click to expand...

'Course, on a Tablet PC, a VLOOKDOWN() may well be horizontal. It
could be called LOCOTHROW() (for LOok at COlumns, THen ROWs)...
Perhaps we should just call it GEORGE().
 
And when you go to the telephone book and peruse down the columns to
find your friend's telephone number, do you think we ought to refer to
that as "looking down his telephone number"?

Alan Beban
 
Back
Top