Rank using VLookup?

[John]

HI. I was wondering if there was a way to use the rank
function with vlookup to find out the rank of a student's
grade from another worksheet? I have five worksheets in
my gradebook. I transer all the grades to the various
worksheets using the Vlookup function and a drop down
box. What I want to do is make a column for what the rank
was on each test that the students have taken. I have
tried to use a variety of different ways but none of them
worked. I ran out of room when I tried to insert a new
column for every test for the year so I cannot make a
separate rank column for each test.

What I need is to say is if A20 on my "1st Trimester
Sheet" =1, then i need to lookup on the master test sheet
what their rank was in column a4:a26

Is there a way this can be done? Thanks for any help!

 

[Paul Corrado]

John

To combine with a VLOOKUP you would need something like names in Col A and
grades in B through whatever.

So to lookup a rank for the first test

=RANK(VLOOKUP("name","score table",2,FALSE),$B$4:$B$26)

PC