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?

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?