One simple way if not too many is to nest ifs starting the the highest.
=if(a1100,1,if(a150,2,"no"))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Kim M." <Kim wrote in message
...
I am trying to create a function similar to VLOOKUP, but different. I have
a
range of numbers, and I need the function to look at the starting number
and
see if it is between, for example, 0 and 50 dollars, and if it is, return
one
value. If it is between 50 and 100, another, etc. VLOOKUP doesn't do
between,
just exact. What I am looking for is like what you do on your income tax
form, where you look for your wages between certain numbers. Does anyone
have a suggestion?