View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kim M. Kim M. is offline
external usenet poster
 
Posts: 1
Default Data lookup function in Excel

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?