Help with a formula (array?) to do the following

[halesowenmum]

I have cell K12 in which a summed value is displayed. There are thresholds (reflected by CF colouring). That's by the by I realise. These relates to subjective descriptions of low, medium, high, extra high.

In the cell below (in K13) what do I need to put in to get, depending on the score, the following text results:
If k12 = to 20 "Low"
If k12 between 21 and 50 "Med"
If k12 between 51 and 90 "High
If k12 between 91 and 160 "Med"

How do I do that (I'm ok with a single one of these but not the stringing together correctly!).

Thank you!

<tbody>
</tbody>

 

[FormR]

Hi, you can try:

=LOOKUP(K12,{0,21,51,91},{"Low","Med","High","Extra High"})

 

[Scott T]

I assume that the second "Med" should be extra high and anything under 20 should be low and anything over 91 should be extra high

=VLOOKUP(K12,{0,"Low";21,"Med";51,"High";91,"extra high"},2)

 

[halesowenmum]

Got to FormRs suggestion first which works great. Thanks so much!