I am doing some data analysis and -I am quite new to excel and a formula I am trying to input does not seem to work. I have marks /grades ---- ie 3-,3,3+ 4-,4,4+ etc and I am trying to use a formula to assign numerical values so that I can get the top student in the group. =LOOKUP(B6,{"3-","3","4","4+"},{"1","2","3","4"}) I tried this but it does not work-its fine for the 3- and 4+ but not for 3,4

Thanks for your help.