Return a Value

[Rajaa S.]

Hi,

How would I return a grade value (A2:A17) if the total score falls between a min and max value (B2:C17)? Please refer to example sheet attached.
Thanks.

[sweep]

Hi,

Use this formula

=INDEX($A$2:$A$17,MATCH(D20,$C$2:$C$17,-1))

after inverting the table (grade 16 at the top)

[Ron Coderre]

Using your posted workbook...Try this:

Please Login or Register  to view this content.

Copy that formula across through H21.

Does that help?

[Rajaa S.]

Hi,
Thank guys for the help. I prefered to use Ron's formula because i prefer not to invert the table. & it worked fine.
Thank you.