Getting Grades

  • Thread starter Thread starter snax500
  • Start date Start date
S

snax500

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
 
Hi
try the following formula
=INDEX($B$1:$D$1,1,MATCH(B2,OFFSET('data'!$B$2:$D$2,MATCH(A2,'data'!$A$
2:$A$10,0)-1,0),0))
 
Thanks for the reply. However it appears that the formula works only if it
is looking up an exact number. For example, if I have the following:

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

and I lookup:

name amount grade
z 11 B

thanks
 
Hi
try
=INDEX($B$1:$D$1,1,MATCH(B2,OFFSET('data'!$B$2:$D$2,MATCH(A2,'data'!$A$
2:$A$10,0)-1,0),1))
 
Back
Top