Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a reference table where Grades are assigned a grade point value
ex: A = 4.0 A- = 3.67 B+ = 3.33 etc... I was wondering if I can reference this table from another cell so that the user can input the letter grade and it recognizes is as the grade point value? |
#2
![]() |
|||
|
|||
![]()
With a VLOOKUP table, see
http://www.mvps.org/dmcritchie/excel/vlookup.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "EZimm" wrote in message ... I have a reference table where Grades are assigned a grade point value ex: A = 4.0 A- = 3.67 B+ = 3.33 etc... I was wondering if I can reference this table from another cell so that the user can input the letter grade and it recognizes is as the grade point value? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel - pivot table - how do i format cells with data mm/dd/yyyy . | Excel Worksheet Functions | |||
Use Excel to make an update query to another database table? | Excel Discussion (Misc queries) | |||
Can't link cells in worksheets in same workbook | New Users to Excel | |||
Password protect cells PivotTable & allow the Pivot Table to refre | Excel Worksheet Functions | |||
Pivot table, how do you exclude counting cells with formulas as a | Excel Worksheet Functions |