Is there a function in excel where you can look up a number range and return
a value, rather than having to type out the full number range in a standard
vlookup function. For example, for vehicle numbers 1 - 50 I want to return a
type description "Car". I will have approx 60 different number ranges e.g.
1-50, 51-100, 101-150..etc.etc.