abc MICROSOFT EXCEL 2010 - VLOOKUP - HLOOKUP
VLOOKUP - student grades, description grade

Grade sutdent by using table for grading

Učenik
Bodovi
Učenik 1 64
Učenik 2 59
Učenik 3 72
Učenik 4 84
Učenik 5 88
Učenik 6 58
Učenik 7 98
Učenik 8 75
Učenik 9 68

Picture 1.Student score

Picture 2. Grade scheme

   

Picture 3. document after counting

Picture 4. student scorei ocjene

   
 

Picture 5. Formula u ćeliji C2

 

cell content C2 is=VLOOKUP(B2;$E$2:$F$6;2)

VLOOKUP - student grades, description grade, steps:

  1. Student name,points and grading scheme
  2. Choose cell for grade (C2).
  3. = beging of the formula.
  4. Enter VLO pressing on TAB rest of the formula is chosen VLOOKUP(
  5. Cell with points (B2) .
  6. Range with grade scheme (E2:F6).
  7. Apsolute range of the adress ($) we get by pressing function key
  8. To choose grade we use secind collom from grade scheme(2).
  9. Set mouse on marker fill .
  10. Double click
  11. Fill formula for rest of the cells is done by doubl clicking mouse on marker fill
  12. The end (Kraj).

 Index