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,...
Louis,
LOOKUP() requires the lookup vector in ascending order.
And ascending order ist not:
| A |
| A- |
| B+ |
| B |
| B- |
| C+ |
| C |
| C- |
| D+ |
| D |
| D- |
| F |
but:
| A |
| A- |
| B |
| B- |
| B+ |
| C |
| C- |
| C+ |
| D |
| D- |
| D+ |
| F |