Label of Number in a Range

webnntp · May 12, 2004

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 · May 12, 2004

Hi

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

webnntp · May 13, 2004

Works great thank you!!

Andy B said:
Hi

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

Andy B · May 13, 2004

Thanks for the feedback!

--
Andy.

webnntp said:
Works great thank you!!

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