| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function to vlookup and put between?
Hi I have a simple table as follow
85 -3 65 -2 55 -1 50 0 45 1 35 2 15 3 I would like to have a formula or function that would allow me to assign a value based on this table. For example if cell A2 = 47 then that falls between 45 and 50 on the table and would get a value of 0. if cell A3 = 9 then it would be less than 15 and get a value of 3 (I am rounding down). Does that make sense? Can someone help? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
function to vlookup and put between?
Assuming that G2:H8 contains the lookup table, and A2 contains the
lookup value, try... =INDEX(H2:H8,MATCH(A2,G2:G8,-1)) -- Domenic Microsoft Excel MVP www.xl-central.com Your Quick Reference to Excel Solutions In article , John wrote: Hi I have a simple table as follow 85 -3 65 -2 55 -1 50 0 45 1 35 2 15 3 I would like to have a formula or function that would allow me to assign a value based on this table. For example if cell A2 = 47 then that falls between 45 and 50 on the table and would get a value of 0. if cell A3 = 9 then it would be less than 15 and get a value of 3 (I am rounding down). Does that make sense? Can someone help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| Embedded VLOOKUP function within IF function | Excel Worksheet Functions | |||
| HOW DO I NEST THE VLOOKUP FUNCTION WITH THE LEFT FUNCTION | Excel Worksheet Functions | |||
| how do I write a vlookup function within an iserror function so t. | Excel Worksheet Functions | |||
| I want to use Vlookup function and AND function in a single formu. | Excel Worksheet Functions | |||
Linear Mode
