how can I get excel to convert a kids key stage 3 level into a numerical value eg 8 = 13, 7a=12, 7b=11 7c= 10 6a= 9 etc and back again?
Create a reference table somewhere where the corresponding values are listed next to each other and use vlookup or match&offset to return the correct one.
Or use a long-winded conditional statement.
My preference is the former.
Vlookup would be my starting point...
Edit: as stoner just said! Like him, I'd shy away from an epic if statement, they can be dreadful to alter or debug!
thanks I'll try that later ans will no doubt be back with further questions!!
I'm here all morning
You must log in to post.