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!
Bookmarks