How to make letter grade in one column equal a number in another?

[Kraner]

Should be simple, just blanking today.

I have a mixture of A, A-, B+, B, and B- in one column and would like to correspond them to 50, 40, 30, 20, and 10. It would be great if I could change the corresponding numbers easily too, just incase.

Thanks!

 

[FormR]

Hi, you could create a lookup table and use VLOOKUP() for example:

Excel 2012
	A	B	C	D	E
1	A-	40		A	50
2				A-	40
3				B	30
4				B-	20
Sheet1

Cell Formulas
Range	Formula
B1	=VLOOKUP(A1,$D$1:$E$4,2,0)

 

[bbott]

Another option:

=CHOOSE(MATCH(A1,{"A","A-","B+","B","B-"},0),50,40,30,20,10)

 

[Kraner]

Quite handy! Thanks!