I am sorting pupils grades, and would like to show their progress in a line graph. The only problem is that the grades are not numerical.

I would like it so that whenever I put in the grade, it is assigned a numerical Value for the chart.

So, the lowest grade is P1c So would like that to be (1) then P1b (2) P1a (3) P2c (4) etc.

Is this possible?

This is what I have tried so far

Then the look up is on a seperate tab

`VLOOKUP`

. See here for more info – cybernetic.nomad Dec 3 '18 at 15:39