Thread: Getting Grades
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
snax500[_2_] snax500[_2_] is offline
external usenet poster
 
Posts: 29
Default Getting Grades

In Excel2000, I have the following data:

Name A B C
x 10 12 14
y 8 6 4
z 15 10 8

I want to be able to look up name and then amount and then give me
Grade (A,B,C) like this:

Name Amount Grade
x 12 B - lookup


What's the easist way to do this?

Thanks