Label of Number in a Range

[webnntp]

I have set a high and low range of values with a correponding label,
how do I return the label of the range where the data point fits?
For example,

ColA ColB ColC

5 10 Low
11 20 Medium
21 30 High

D1 has the value 13 how do I get E1 to return the label "Medium"

Thank you

 

[Andy B]

Hi

Try:
=VLOOKUP(D1,A2:C4,3)

 

[webnntp]

Works great thank you!!

Hi

Try:
=VLOOKUP(D1,A2:C4,3)

 

[Andy B]

Thanks for the feedback!

--
Andy.

Works great thank you!!

"Andy B" <[email protected]> wrote in message