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

Getting Grades
 

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))


--
Regards
Frank Kabel
Frankfurt, Germany


snax500 wrote:
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

Getting Grades
 

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




"Frank Kabel" wrote in message
...
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))


--
Regards
Frank Kabel
Frankfurt, Germany


snax500 wrote:
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

Getting Grades
 

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))

--
Regards
Frank Kabel
Frankfurt, Germany


jessica gottschalk wrote:
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




"Frank Kabel" wrote in message
...
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))


--
Regards
Frank Kabel
Frankfurt, Germany


snax500 wrote:
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