| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Can I link cells to a reference table I make?
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 | |
|
|
Similar Threads
|
||||
| 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 | |||
Linear Mode
