Selecting from a list of text according to a range of values

I am trying to create a formula in Excel that will select from a list of different text statements in response to a varying figure in another column. I’d really value. I’m not an advanced Excel user

A pictorial way of putting it is
A Between 0 and 10
B Between 11 and 30
C Between 31 and 40
D Between 41 and 60
E Between 61 and 70
F Between 71 and 100

x If x = A then return “one”
If x = B then return “Two”

Etc

Etc


One

Two

Three

Four

Five

six

I’ve played around with IF and MATCH and INDEX and DGET but can’t quite manage it.
Would be very grateful for help
Thanks
Peter

Sorry it's not as clear as it was within the table form that dropped out as i posted!

See if this workbook helps

You could try something like this :

Formula:

=LOOKUP(A1,{0,11,31,41,61,71},{"One","Two","Three","Four","Five","Six"})

Hope this helps

This example is with a lookup table, F2:G7.

This is easier to maintain than a fixed formula.