Forum menu
Topic starter
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?
Posted : 25/06/2013 9:49 am
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.
Posted : 25/06/2013 9:52 am
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!
Posted : 25/06/2013 9:52 am
Topic starter
thanks I'll try that later ans will no doubt be back with further questions!!
Posted : 25/06/2013 9:58 am
I'm here all morning 🙂
Posted : 25/06/2013 10:05 am