I'm using Excel 2002 and I have used VLookup for a markbook but it gives me a #N/A error. There are three marking criteria (KAPS, MAPS and CAJ) and when those three cells are filled in with a mark (A+ to E-), I wanted the end result to show up as an average (Example: A for KAPS, C for MAPS and A for CAJ = B+ overall). I can attach my markbook if anyone wants to view the problem in more detail. I didn't expect this to be so complicated... or is there something I missed?
Bookmarks