Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I set up vlookup formula.
I am a student trying to set up a vlookup formula for an assignment: grading
criteria. One workbook w/4 sheets. One sheet w/look up values and 3 sheets for misc students w/three exams each. One formula to average the overall grade in each cell per student SHEET 2 GRADING CRITERIA A1 B1 EXAM AV 0-40 F 41-50 D A1 B2 etc each student has student exam1 exam2 exam3 E2 overall letter grd ssn 75 80 92 =average(Cells A:B) Grd formula: VLOOKUP(E2,"GRADINGCRITERIA,A$2$:B$6$,2,TRUE) I get #REF error message. Any suggestions please. |
#2
|
|||
|
|||
How do I set up vlookup formula.
See reply in latter post.
Biff "Julie" wrote in message ... I am a student trying to set up a vlookup formula for an assignment: grading criteria. One workbook w/4 sheets. One sheet w/look up values and 3 sheets for misc students w/three exams each. One formula to average the overall grade in each cell per student SHEET 2 GRADING CRITERIA A1 B1 EXAM AV 0-40 F 41-50 D A1 B2 etc each student has student exam1 exam2 exam3 E2 overall letter grd ssn 75 80 92 =average(Cells A:B) Grd formula: VLOOKUP(E2,"GRADINGCRITERIA,A$2$:B$6$,2,TRUE) I get #REF error message. Any suggestions please. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup formula - Excel Version 2002 | Excel Worksheet Functions | |||
Need Vlookup to work with formula in reference cell | Excel Discussion (Misc queries) | |||
What can I add to a vlookup formula to give me a 0 not #n/a | Excel Worksheet Functions | |||
Using Vlookup in formula arrays | Excel Worksheet Functions | |||
Vlookup formula using tax yables | Excel Worksheet Functions |