abc MICROSOFT EXCEL 2010 - VLOOKUP - HLOOKUP
VLOOKUP - student grades, numerical values

Grade sutdent by using table for grading

Učenik Bodovi
Učenik 1 83
Učenik 2 64
Učenik 3 50
Učenik 4 66
Učenik 5 61
Učenik 6 69
Učenik 7 65
Učenik 8 92
Učenik 9 53

Picture 1.Student score

Picture 2. Grade scheme

   
Picture 4. document after counting

Picture 4. student scorei ocjene

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

VLOOKUP -student grades, numerical values, 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 second column 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