Re: Number range function

I'd create a list like this in sheet2!a1:b##:

1 car
51 truck
101 Van
151 Firetruck
201 policecar
....


Then use:
=vlookup(a1,sheet2!a:b,2)

Note that there isn't a False or 0 as the last parm in the function.

Sonya T wrote:
>
> 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.

--

Dave Peterson
.