Spreadsheet: 37948d1236067575-vlookup-with-multiple-tables-15-to-be-exact-final-project-2
Sheet: Semester Tables

Semesters
Below are tables where you can enter in class titles, whether they are completed or scheduled classes, the credits per class, and the grade received. These tables will only allow for five years. Any longer and this sheet will not be applicable. If the classes are scheduled, please select N/A for credits and Grade. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This index shows the classes you've  input on all 15 semesters in order
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Index for | index for | Index for |  | Index | Classes | Semester | Status | Credits | Grade |  |  | Semester Table
Fall of | 2009 |  |  |  | Spring of | 2010 |  |  |  | Summer of | 2010 |  |  |  | Fall of 2009 | Spring of 2010 | Summer of 2010 |  | 1 | UNI 101 | Fall of 2009 | Complete | 3 | A |  |  | 1 | Fall of 2009
Class | Status | Credits | Grade |  | Class | Status | Credits | Grade |  | Class | Status | Credits | Grade |  |  |  |  |  | 2 | [NAME] I | Fall of 2009 | Scheduled | N/A | N/A |  |  | 11 | Spring of 2010
UNI 101 | Complete | 3 | A |  | Philosophy | Scheduled |  |  |  |  |  |  |  |  | 1 | 11 |  |  | 3 | Natural Science | Fall of 2009 | Scheduled | N/A | N/A |  |  | 21 | Summer of 2010
[NAME] I | Scheduled | N/A | N/A |  | MTH 161 or 171 | Scheduled |  |  |  |  |  |  |  |  | 2 | 12 |  |  | 4 | Natural Science Lab | Fall of 2009 | Complete | 2 | [NAME] |  |  | 31 | Fall of 2010
Natural Science | Scheduled | N/A | N/A |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  | 11 | Philosophy | Spring of 2010 | Scheduled | 0 | 0 |  |  | 41 | Spring of 2011
Natural Science Lab | Complete | 2 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  | 12 | MTH 161 or 171 | Spring of 2010 | Scheduled | 0 | 0 |  |  | 51 | Summer of 2011
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 61 | Fall of 2011
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 71 | Spring of 2012
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81 | Summer of 2012
Total |  | 5 |  |  | Total |  | 0 |  |  | Total |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 91 | Fall of 2012
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Index for | index for | Index for |  |  |  |  |  |  |  |  |  | 101 | Spring of 2013
Fall of | 2010 |  |  |  | Spring of | 2011 |  |  |  | Summer of | 2011 |  |  |  | Fall of 2010 | Spring of 2011 | Summer of 2011 |  |  |  |  |  |  |  |  |  | 111 | Summer of 2013
Class | Status | Credits | Grade |  | Class | Status | Credits | Grade |  | Class | Status | Credits | Grade |  |  |  |  |  |  |  |  |  |  |  |  |  | 121 | Fall of 2013
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 131 | Spring of 2014
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 141 | Summer of 2014
Total |  | 0 |  |  | Total |  | 0 |  |  | Total |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Index for | index for | Index for
Fall of | 2011 |  |  |  | Spring of | 2012 |  |  |  | Summer of | 2012 |  |  |  | Fall of 2011 | Spring of 2012 | Summer of 2012
Class | Status | Credits | Grade |  | Class | Status | Credits | Grade |  | Class | Status | Credits | Grade
Total |  | 0 |  |  | Total |  | 0 |  |  | Total |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Index for | index for | Index for
Fall of | 2012 |  |  |  | Spring of | 2013 |  |  |  | Summer of | 2013 |  |  |  | Fall of 2012 | Spring of 2013 | Summer of 2013
Class | Status | Credits | Grade |  | Class | Status | Credits | Grade |  | Class | Status | Credits | Grade
Total |  | 0 |  |  | Total |  | 0 |  |  | Total |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Index for | index for | Index for
Fall of | 2013 |  |  |  | Spring of | 2014 |  |  |  | Summer of | 2014 |  |  |  | Fall of 2013 | Spring of 2014 | Summer of 2014
Class | Status | Credits | Grade |  | Class | Status | Credits | Grade |  | Class | Status | Credits | Grade
Total |  | 0 |  |  | Total |  | 0 |  |  | Total |  | 0