Let's say that your table is in A1:B8
In C1, I enter some text like: C+
In D1 I can use =VLOOKUP(C1,A1:B8,2,FALSE) to give me the result 2.5
Of course, your table could be on another sheet and then we use
=VLOOKUP(C1,Sheet3!A1:B9,2,FALSE)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Ron" wrote in message
...
I want to take a table that shows text in a column for several rows, but
the
text in each row represents a number that I can average?
Here's the table - If I want the A+ to represent a number when O enter A+,
how do I do that?:
A+ 4.5
A 4
B+ 3.5
B 3
C+ 2.5
C 2
D+ 1.5
D 1
F 0