View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nick Horn Nick Horn is offline
external usenet poster
 
Posts: 14
Default Converting Letter Grade to Numerical Value

I am using VLOOKUP to convert letter grades to numerical grades. I need to
avoid generating #N/A and just have a blank cell when a cell does not contain
a letter grade; e.g.

Letter Grade Column Returned Numercial Grade
A 1
B 2
(At the moment using VLOOKUP
generates #N/A
E 5

Many thanks