| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
| Lookup Function for Data Validation | Excel Worksheet Functions | |||
| Data lookup function | Excel Worksheet Functions | |||
| Lookup and Move Data Function Help | Excel Worksheet Functions | |||
| AGAIN... I need another Lookup Function to extract some data | Excel Worksheet Functions | |||
Threaded Mode
