Is the range a text value like you've shown it here?
I also need to do this. I am trying to take aggregated measures and match to upper/lower limit ranges. I'm not sure it's possible without using a stored procedure. Interested to know if anyone else has done anything similar.