Forum Discussion
Excel "LOOKUP" formula help
I'm using the following formula to lookup my letter grade and and convert that into grade points.
=LOOKUP(E27,{"A","A-","B+","B","B-","C+","C","C-","D+","D","D-","F"},{4,3.67,3.33,3,2.67,2.33,...
Another variant
=IFNA(CHOOSE(MATCH(E27,{"A","A-","B+","B","B-","C+","C","C-","D+","D","D-","F"},0), 4,3.67,3.33,3,2.67,2.33,2,1.67,1.33,1,0.67,0),"")