Changing Student Marks...

[Sabotage1945]

Thanks guys for your help!

I was able to use Alan's suggestion and it worked - but I hate to hav
to make a 2nd 'table' every time as I have so many files/sheets t
process (not complaining though ).

I had tried both of these but I can't seem to get them to wor
properly. When I attempt to add this to my sheet (and slightl
modifying it to match my sheet cells), I get the following incorrec
result:

Modified version:
=IF(E3="","",VLOOKUP(E3,{"A+",10;"A",9;"A-",8;"B+",7;"B",6;"C+",5;"C",4;"D+",3;"D+",2;"E",1;"F",0;"INC",0;"ABS",0},2))

Result:
E2 has "A+", but the result is incorectly listed as "8".


Modified version:
=LOOKUP(E2,{"A+","A","A-","B+","B","C+","C","D+","D","E","F","INC","ABS"},{"10","9","8","7","6","5","4","3","2","1","0","0","0"})

Result:
E2 has "A+", but the result is incorectly listed as "8"....

Both of these results should come up with "10".

Thanks again,
Sab

 

[Max]

Modified version:

=IF(E3="","",VLOOKUP(E3,{"A+",10;"A",9;"A-",8;"B+",7;"B",6;"C+",5;"C",4;"D+"
,3;"D+",2;"E",1;"F",0;"INC",0;"ABS",0},2))

Result:
E2 has "A+", but the result is incorectly listed as "8".

Think you need to specify the VLOOKUP's 4th arg as : FALSE or "0"
to hunt for an exact match instead
(Omitting it implies TRUE)

Try instead (with TRIM() added:

=IF(TRIM(E3)="","",VLOOKUP(TRIM(E3),{"A+",10;"A",9;"A-",8;"B+",7;"B",6;"C+",
5;"C",4;"D+",3;"D",2;"E",1;"F",0;"INC",0;"ABS",0},2,0))

[ TRIM() added to help improve robustness in matching, it'll remove any
stray
leading or trailing "invisible" spaces in the lookup value ]

The above should now return the correct results

(Corrected a typo as well for grade "D": ... "D",2 .. <g>)