Thread: VLookup Tables
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jo-Jo Jo-Jo is offline
external usenet poster
 
Posts: 1
Default VLookup Tables

I am a teacher and trying to make my grades electronic instead of manual. I
have the number grades calculated however; I wanted excel to automatically
translate the numeric grade into a letter grade. For example if the numeric
grade is a 90 than in the next column I want excel to put an A- in the field.
I tried to do that with creating a separate worksheet for the VLOOKUP that
lists the numeric grade associated with the letter grade but I don't
understand how to do it.