i am wanting for excel to return a value based on a number falling within a range. i have attached the sheet for those who might want to take the challenge. i want the order out column to return the corresponding L column based on which range the G column falls in. so for cell E5 it should return "2nd" for cell E10 it should return 1st and so on. i need a formula to do this but i cant get it to work since the values can fall in more then one range.